Formula to reflect name in header table

[snmark]

Hi
ive created a very simple table with four names in the top row in seperate columns, B,C,D, and E.. under each name is a golf score, eg: 82,87,79, 92. Column A has the date for each round. I'd like a formula in column F rows extending down to show the name of the winner of each weeks score ie: the lowest score showing the persons name! Who won that weeks game. Thank you.

stephen

 

[RoryA]

What if there's a tie?

Also, please update your account details to indicate which version of Excel you are using as it will affect what solutions are available to you.

 

[snmark]

Hmm, well it should reflect two names in the column right? The two with the lowest score!, hopefully
Thanks Rory

 

[RoryA]

OK, assuming header in row 1:

=TEXTJOIN(",",TRUE,IF(B2:E2=MIN(B2:E2),$B$1:$E$1,""))

 

[snmark]

Thank you Rory, I will let you know if this works.

 

[snmark]

Just tried it Rory, I had to change the row numbers as the headers were in row 2 , but it works beautifully.
Thank you so much
Stephen

 

[RoryA]

Glad we could help.

 

[snmark]

Just one question Rory, when I dragged down to fill the formula in the rows below, it filled in all four names, is there a way to keep those rows empty till the scores are added?
sorry to be a pain.
stephen

 

[RoryA]

You could use something like:

=IF(B3>0,TEXTJOIN(",",TRUE,IF(B3:E3=MIN(B3:E3),$B$2:$E$2,"")),"")

so it will only populate once a number has been entered into column B

 

[snmark]

You, Rory, are a star. Thank you so much.
all the best
Stephen