Including "Ties" in MIN INDEX Result

I have a cell that reports the lowest score and identifies the person with that score. I need to know how I can include the result in the same cell if there are two or more with the same lowest score.

Here is what I am using to get the name and score in the cell now:

=MIN(Z$5:Z$32)&"-"&INDEX($B$5:$B$32,MATCH(MIN(Z$5:Z$32,0))

What can I do to make the code include more than one lowest score with the corresponding name?

It would be much simpler to separate the matching names in separate cells rather than combine into one cell.

If that is okay, then in a helper column, say AA5, enter:

=IF(Z5=MIN($Z$5:$Z$32), COUNT(AA$4:AA4)+1,"")

copied down

Then to get matching names to the Min:

=IFERROR(INDEX($B$5:$B$32,MATCH(COLUMNS($A$1:A$1),$AA$5:$AA$32,0)),"")

copied across as far as you want.

I tried this and it repeated the same low name in the adjacent column. I want to show all the names with the low score.

I did the codes you suggested. The first in AD5. And copied down to AD 32. The second I put in T1. And copied to AA1. Each cell has the same name. There should be at least three names. Also what happened is that it placed 1, 2, and 3 in the AD column corresponding to the low score. I guess that was a count...?

See attached.

I only filled up half the names.. but same applies down to row 32....

If you have multiple results, then I suggest a little different method..

In S1 enter:

Please Login or Register  to view this content.

to get the min

then in S2 enter:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER to get next smallest, and copy down as far as you need to get next smallest values.

Then in T1:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and not just ENTER and copied down and across as far as needed.

See attached.

Note: Column AD helper wouldn't be needed in this case.

Well, that works fine for what I described. I really appreciate the time you took to help me with this. However, I gave a wrong description of what I need to accomplish.

The problem is that there are only four places that would be awarded for the four lowest points. So if there is a three way tie for 1st, then there would not be a 2nd and 3rd place. The next place would be 4th. In the scenario with the codes we have here, too many ties become available. The list would show scores and names that would be too many places than are supposed to be awarded. While this is exactly what I said I needed, it actually is not.

Need to think this over. After a night's sleep.

Thank you for your thorough and quick replies.

Maybe you meant as per atttached then...

In S1: =SMALL($Z$5:$Z$32,ROWS($A$1:$A1)) copied down

This extracts the smallest 4 values (which could contain repeats).

Then in T1:

=INDEX($B$5:$B$32,SMALL(IF($Z$5:$Z$32=$S1,ROW($Z$5:$Z$32)-ROW($Z$5)+1),COUNTIF(S$1:S1,S1)))

confirmed with CTRL+SHIFT+ENTER and copied down.

This extracts unique names to each low value.

Hooray!!!

That is exactly what I need to use. I can now link those scores and matching names to our recap sheet without having to key them in individually.

I have learned a lot with this exercise. The site is wonderful.

You have been a great help. Your diligence is only out performed by your knowledge. Thanks a bunch.

You are welcome,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Also, please don't quote entire posts, it adds unnecessary clutter to the threads.