I am trying to create a list of people based on interest. I need the sheet to pull from 4 different groups into one and list each person by age. I have made a sheet showing what I need but without the function. Can someone please show me how to make and so that it does not come up with the #NUM! error if it doesn't exist.
Looking to take each list (4) added together and match with the Title of Volleyball or Soccer and then list each person who matches by age highest to lowest.
<tbody>
</tbody>
Looking to take each list (4) added together and match with the Title of Volleyball or Soccer and then list each person who matches by age highest to lowest.
| Name | Age | Sport | Name | Age | Sport | Name | Age | Sport | Name | Age | Sport | Volleyball | Soccer | ||||||||
| Beth | 10 | Soccer | Kyle | 11 | Volleyball | Ryan | 9 | Soccer | Kevin | 10 | Soccer | 11 | Kyle | 11 | Chris | ||||||
| Sarah | 8 | Volleyball | Terry | 10 | Soccer | Carl | 10 | Volleyball | 10 | Carl | 10 | Beth | |||||||||
| Chris | 11 | Soccer | Tim | 9 | Volleyball | 9 | Tim | 10 | Kevin | ||||||||||||
| Ray | 9 | Soccer | 8 | Sarah | 10 | Terry | |||||||||||||||
| 9 | Ray | ||||||||||||||||||||
| 9 | Ryan | ||||||||||||||||||||
<tbody>
</tbody>
