# Using Min and if to produce a text response

#### ajt8888

##### New Member
This is probably very straightforward but its doing my head in, can someone help I have a worksheet which has two columns one with Names the other with value, all i need is a formula in column 3 that will return for each individual "lowest" for the lowest value attributed to that person and "ignore" to the rest of the values for that person. Many thanks in advance.

 Name Value Harry 567 Harry 568 Harry 569 Harry 570 Harry 571 Dave 459 Dave 460 Dave 461 Dave 462 Dave 463 Dave 464 Pete 333 Pete 331 Pete 332 Pete 333 Pete 333 Pete 338 Steve 172 Steve 173 Steve 174 Steve 175 Steve 176 Steve 177 Steve 177 Steve 177 Steve 177 Steve 177 Steve 177

<tbody>
</tbody>

<tbody>
</tbody>

#### James006

##### Well-known Member
Hello,

In cell C2, you can have following Array formula

Code:
``=MIN(IF(\$A\$2:\$A\$29=A2,\$B\$2:\$B\$29))``
Instead of the Enter key ... use simultaneously the 3 keys : Control Shift Enter

Hope this will help

Last edited:

#### ajt8888

##### New Member
James thanks but that is not what was required, what I want is a formula that identifies the lowest number and puts the word lowest into cell c2 or if its not the lowest then ignore

Hello,

In cell C2, you can have following Array formula

Code:
``=MIN(IF(\$A\$2:\$A\$29=A2,\$B\$2:\$B\$29))``
Instead of the Enter key ... use simultaneously the 3 keys : Control Shift Enter

Hope this will help

#### James006

##### Well-known Member
Hello again,

Have a try with:

Code:
``=IF(B2=MIN(IF(\$A\$2:\$A\$29=A2,\$B\$2:\$B\$29)),"Lowest","")``
HTH

#### ajt8888

##### New Member
Thanks James thats great

Hello again,

Have a try with:

Code:
``=IF(B2=MIN(IF(\$A\$2:\$A\$29=A2,\$B\$2:\$B\$29)),"Lowest","")``
HTH

#### James006

##### Well-known Member
You are welcome ...