use formula to find the smallest number, and who it belongs to

**daisydaisy** · 12-24-2010, 05:38 AM

I need a formula that finds the minimum number in a column (B), and then tells me what name is associated with it in Column (A).

Column A is names of people
Column B is numeric amounts

I've attached an example. Answer should read "3 Terry" "Terry 3" or any variation. . If it's not possible to read 3 Terry, maybe have the formula just name Terry.

Thanks in advance!

**DonkeyOte** · 12-24-2010, 05:49 AM

Perhaps:

Please Login or Register  to view this content.

**daisydaisy** · 12-24-2010, 05:56 AM

Sweet, that worked great! Thank you! If you possibly have the time, could you explain the code to me just so it will be easier to remember for future reference?

**DonkeyOte** · 12-24-2010, 06:19 AM

MIN returns the lowest value.
MATCH finds the position of the lowest value in the precedent range
INDEX with MATCH retrieves associated name
The use of & concatenates the MIN value with the Name.

For a more in depth understanding see the help files re: each function

Going forward please do not quote prior posts in their entirety - quote only those parts necessary to maintain a logical flow to your subsequent post (if any).