Adding a Name Cell to a MIN Result

**bobbby1949** · 08-09-2010, 04:21 PM

I would like to add the name to the cell that contains the smallest number in a score sheet.

Attached is a sample of what I am using. Where the MIN result cell shows the number, I would also like to add the corresponding name in that row.

**NBVC** · 08-09-2010, 04:40 PM

You can use:

=INDEX($A$2:$A$11,MATCH(C12,C$2:C$11,0))

copied down and to next column, but this will get only first name that matches the minimum, if there are several minimum matches.

If you want all matches, then perhaps:

=IF(ROWS($A$1:$A1)>COUNTIF(C$2:C$11,C$12),"",INDEX($A$2:$A$11,SMALL(IF(C$2:C$11=C$12,ROW(C$2:C$11)-ROW(C$2)+1),ROWS($A$1:$A1))))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down as far as you need to ensure all matches retrieved and then copy to next column.

**bobbby1949** · 08-09-2010, 05:23 PM

Hmmm. I'm afraid I may not have asked my question correctly.

The current formula already gives a unique result for the minimum number. It will not provide a number that is a duplicate. I would like to substitute the number with the name that corresponds.

In my example it currently is:

B12- "Blank" C12- 3 D12- 5

I want it to be:

B12 - "Blank" C12- George D12- Tom

Also, to make it more difficult, I will be using the cells in columns and rows from a different sheet in the workbook.

Sorry for my confusing you. It's just that I am confused...