I have a sheet where the players select 6 numbers, and if they get the correct numbers, they get a "1" in the total column, if they get 1-5 correct, they get a “0” in the total column. Every player selects 6 numbers out of 28 total, 14 of them are correct. I have the correct numbers at the top of the sheet and have a formula automatically telling me if they got all 6 right or not. What Im asking is: Is there a code that I can put in a cell at the top that will tell me which player #s have won so I can just simply look at the cell and tell who won? There are 221 players, column A is ranged A8-A228 and the total column is in Column K.
1..3..6..8..9..11..13..16..17..19..21..24..25 - Correct numbers
PLAYER--Pick 1--Pick 2--Pick 3--Pick 4--Pick 5--Pick 6----Total
----1-------1--------3--------8-------17-----21-------25--------1
----2-------2--------4--------7-------19-----22-------25--------0
So in the cell telling me who won, It would have to tell me the Player number only. I dont know if this is possible, but if you could help me that would be great, thanks a lot!
Would be good to have a column of winners:
Winners:
1
132
201
Thank you for all your help.
1..3..6..8..9..11..13..16..17..19..21..24..25 - Correct numbers
PLAYER--Pick 1--Pick 2--Pick 3--Pick 4--Pick 5--Pick 6----Total
----1-------1--------3--------8-------17-----21-------25--------1
----2-------2--------4--------7-------19-----22-------25--------0
So in the cell telling me who won, It would have to tell me the Player number only. I dont know if this is possible, but if you could help me that would be great, thanks a lot!
Would be good to have a column of winners:
Winners:
1
132
201
Thank you for all your help.