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

 

[snmark]

Hi Rory, what if I wanted to show in the next columns rows the names of the ones coming second, third and fourth! Do I add something after the "MIN" like +2 in the formula? and put that formula in the next row etc: or am I being too simplistic, probably!
Thanks again

Stephen

 

[snmark]

Hi Rory
I was wondering if it would be possible to add something to the formula that would add the names of second, third and fourth in the row in subsequent columns. ie the lowest score would be the winner with others scores coming in 2nd, 3rd and 4th if you get what I mean! The new formula going into the row and each column. the columns being numbered 1,2,3 and 4.
Thanks again for your help.

Stephen

 

[RoryA]

Do you still want ties to end up in the same cell(s)? If so, let's say you have two tied for first; should the next name go in slot 2 or slot 3 (since there are 2 better players)? The latter is easier as that's what a RANK formula would return.

 

[snmark]

Do you still want ties to end up in the same cell(s)? If so, let's say you have two tied for first; should the next name go in slot 2 or slot 3 (since there are 2 better players)? The latter is easier as that's what a RANK formula would return.

Yes please Rory, sounds much better, thank you.

 

[RoryA]

Like this?

Book1
	B	C	D	E	F	G	H	I
2	Name1	Name2	Name3	Name4	1	2	3	4
3	81	75	80	92	Name2	Name3	Name1	Name4
4	75	92	98	92	Name1	Name2,Name4		Name3
5	94	84	89	86	Name2	Name4	Name3	Name1
6	89	82	91	89	Name2	Name1,Name4		Name3
7	94	90	75	84	Name3	Name4	Name2	Name1
8	97	79	94	79	Name2,Name4		Name3	Name1
9	97	83	81	80	Name4	Name3	Name2	Name1
10	93	75	98	77	Name2	Name4	Name1	Name3
11	77	88	75	93
Sheet1

Cell Formulas
Range	Formula
F3:I11	F3	=IF($B4>0,TEXTJOIN(",",TRUE,IF(RANK.EQ($B3:$E3,$B3:$E3,1)=F$2,$B$2:$E$2,"")),"")

 

[snmark]

Oh my gosh Rory, that's exactly what I meant. Genious!
Thank so very much.
stephen

 

[RoryA]