Hello! I am using Excel 2007 to work with a group of 18 players in a Nascar pool. Each player selects between 1 to 18 car numbers (out of a list of 43) based upon their rank for the week. I am trying to create a spreadsheet that will select the first available car from their personal list of picks that looks at the previous rank's numbers so there is no duplication. I have tried using If then nesting functions, but it became cumbersome. Please give some ideas as to the most effcient manner in which we can complete this project.
Below is an example of the table for the picks- I would like to be able to have a formula that will select the next non duplicated number in a person's pick. Example- PERSON3 would have 24 as their selection- since 33 was already selected by PERSON1. Any help would really really be appreciated. THANK YOU!
<TBODY>
</TBODY>
Below is an example of the table for the picks- I would like to be able to have a formula that will select the next non duplicated number in a person's pick. Example- PERSON3 would have 24 as their selection- since 33 was already selected by PERSON1. Any help would really really be appreciated. THANK YOU!
Place | Name | Selection | Pick1 | Pick2 | Pick 3 | Pick 4 | Pick5 | Pick6 | Pick7 | Pick8 | Pick9 | Pick10 | Pick11 | Pick12 | Pick13 | Pick14 | Pick15 | Pick16 | Pick17 | Pick18 |
1 | PERSON1 | 33 | 33 | |||||||||||||||||
2 | PERSON2 | 9 | 33 | 9 | ||||||||||||||||
3 | PERSON3 | 33 | 24 | 18 | ||||||||||||||||
4 | PERSON4 | 33 | 7 | 9 | 27 | |||||||||||||||
5 | PERSON5 | 2 | 35 | 29 | 28 | 5 | ||||||||||||||
6 | PERSON6 | |||||||||||||||||||
7 | PERSON7 | |||||||||||||||||||
8 | PERSON8 | |||||||||||||||||||
9 | PERSON9 | |||||||||||||||||||
10 | PERSON10 | |||||||||||||||||||
11 | PERSON11 | |||||||||||||||||||
12 | PERSON12 | |||||||||||||||||||
13 | PERSON13 | |||||||||||||||||||
14 | PERSON14 | |||||||||||||||||||
15 | PERSON15 | |||||||||||||||||||
16 | PERSON16 | |||||||||||||||||||
17 | PERSON17 | |||||||||||||||||||
18 | PERSON18 |
<TBODY>
</TBODY>