Mystery Skins Golf Game in spreadsheet

[caioz1jp]

WE do a game where we draw a card that has a hole number on it. We then take all the score cards and if one person has the single lowest score they win. If there are multiple people who tie for lowest score they continue and we draw another card. So if we start with 24 people and 5 have the same low score for a particular hole. Only the scores of those 5 people will be checked for against the next hole. this continues until only one person has the lowest score. In my spread sheet i would like A40 to read Mystery? when there is nothing in the cells B40 to T40. Then once i start entering hole numbers in B40 i want A40 to either list a winner or say draw again if there is not a winner yet. I think I need a macro or VB code because I need to designate the hole number to the proper column along with something able to manage a shrinking list of row numbers. Any help would be great. Attached is what i have so far.

2013 Golf Trip DEBUG.xls

[Tiger20]

I've gone looking for someone else to help while I wait for some help on mine and may work on this, but would like some more detail.
You mention A40, and B40 to T40. Confirm we are talking the "Day #" sheets.
B40 appears to me to be not correct as A40 is a merged cell of A40:C40 (B40 no longer exists)
When you nominate a different set for your stated B40 to T40, what do you expect to put in them?
Please supply filled with typical entries so we can have something to work with.
Off to golf, look forward to helping later.

[Tiger20]

I've taken some decisions myself.
I've made you a 3 hole version, if you require more I presume you can follow the principles and apply them for further calculations.
File revised is attached

[caioz1jp]

Hey sorry about the delay in response. Looks good. Ill need to take some time to figure out exactly whats going on but this is close to one way i thought of doing it. Thanks for getting me started.

[caioz1jp]

Is there a way for me to be able to type a hole number in one spot and have another cell able to dtermine the colums and row range from tha. For example if I type 8 in the first box and in another cell start matching lowest scores to names based on a predefined equality. such as If B39=8,INDEX($A4:$A27,MATCH(MIN(I4:I27),I4:I27,0))). Basicly I would have to have 18 If arguments for each hole. Which may have to be done in seprate cells for front and back nine due to quantity limits in excel.

[Tiger20]

Solution as attached expanded to 5 hole.

[caioz1jp]

I used your idea and was able to work it so i could enter the actual hole numbers. Its probably not as neat as it could be but it seems to be working.

2013 Golf Trip Final DRAFT wtest scores.xls

[Tiger20]

Thats good caioz1jp
Glad to be of assistance, you could mark as SOLVED etc