Golf skins output

[xrayservice]

__________________________Output
___A ____B __C __D ____E _____F ____G
___Hole __1 __2 __3 _____1 _____2 _____3
1 Team1 __5 __6 __6 _____0 _____0 _____0
2 Team2 __5 __6 __5 _____0 _____0 _____0
3 Team3 __5 __5 __5 _____0 _____1 _____0
4 Team4 __5 __5 __4 _____0 _____1 _____1
5 _________________sum= 0 _____2 _____1
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Need to display the winner of the skins which would be Team4 on the 3<SUP>rd</SUP> hole.


As you can see I have built the logic in columns E1:G4 to output how many teams had the lowest score for a hole. The skin is won only when one team has the lowest score alone on a hole.

 

[xrayservice]

hmmmm sorry about the spacing

 

[xrayservice]

Dont answer I'll try and correct spacing

 

[Dave Patton]

You can search the forum for similar questions.

http://www.mrexcel.com/forum/showthread.php?t=541033 includes one of the answers that I provided.

 

[Peter_SSs]

I would use a couple of helper rows. I've used rows 1 and 2, which could be hidden after populating them with their formulas.

Formulas in B1 and B2 copied across to the right.

If you don't like the #N/A results when there is no winner, a slight modification could be made.

Excel Workbook
	A	B	C	D
1	4	1	3	4
2	3	FALSE	FALSE	TRUE
3	Hole	1	2	3
4	Team1	5	6	6
5	Team2	5	6	5
6	Team3	5	5	5
7	Team4	5	5	4
8
9	Winner	Team4
10	Hole	3
Skins