Hi Guys,
I'm creating a spreadsheet for a golf competition played over 8 weeks. The competitors can play up to four rounds at some point over the 8 weeks. Some players might play every week or play 6 weeks etc. but only their first 4 scores should count towards the competition. The other are rounds played for fun.
I have 8 values in 8 cells (not together in a range. say cell A3 in 8 separate sheets with sheet 1 being the scores for week 1 and sheet 8 being the scores for week 8) that contain values of the scores on hole 1. The cells may have a number for their score, the cell might say "Picked up" or may say "DNP" (did not play).
Can anybody tell me how I can find the minimum score the player achieved on hole 1 only looking at the first four valid scores the made over the 8 weeks ignoring where the player did not play.
Sorry if this isn't very clear.
Thanks very much.
Bookmarks