Find minimum value(s) in column and gather corresponding name from another column

Hi all,

My first post here and first post ever about excel, forgive me for any forum rules I may be trampling out of ignorance.

I'm working on something golf related. I want to put player names in column A and hole 1 scores in column B, hole 2 scores in column C, etc. Then I want to find the lowest score(s) for hole 1 in column B. There may be several players that tie scores on a hole. So what I am trying to figure out is how to place all of the players names who that tie low score into another cell. Ultimately what I am trying to do is figure out who tied hole 1 and then use hole 2's score as a tiebreaker for those players for hole 1. But my first challenge is this one, so I'll stick to this for now.

I've figured out how to use MIN with the cell range, and to conditional format the lowest scores. I just don't know enough to know how to get the corresponding names from that.

Thanks for any help you can provide.

Mike

It would be very helpful if you could post what you have, with some dummy data, and an example of what you want the resulting output to look like. That way we can design something specifically to your spreadsheet.

Sorry for the delay getting back to this. quekbc, what FDibbins posted is essentially what I'm looking for. In response to Tony, the names don't need to be in the same cell, they can be displayed in separate cells in the same column. I'll play around with your examples FDibbins and newdoverman and let you know if those are going to work for me.

So what I am working on is a scoresheet for a billiard game called golf. The scoring is exactly like golf and it is a very similar game to 3 ball. While 3 ball uses the same rack set up every time, golf uses different ball configurations to get figure par scores.

In 3 ball, if there is a tie, everyone puts in again and this repeats until someone gets a lower score than the rest of the field and they take the pot. A player can shoot terrible the first 5 racks, but as long as two other people tied for lowest score those racks, they have a shot at claiming the pot on rack six. So the good players usually prevail and you only get a couple of large pots per night. This is good for those few people, but it isn't a motivator for the lesser players to think they have a chance to win.

For this golf billiard game, I revised the rules so that each individual rack (or hole) can only be won by those that tied for the lowest score. That way, if a lesser player gets lucky and shoots a low score they can still claim a pot without the good shooters getting mulligans for a tie. This keeps it a bit interesting, but in order to keep things moving along, we just use the next hole and so forth as the tiebreaker for the players that tie a hole.

This scoresheet is to keep drunk people from trying to do math late at night. My excel skills are not great, so I'm learning as I go.