Quote:
Originally posted by Andrew
Looks like its going to get tough to track how many actual teams there are this year once second regional sign up opens in a few days.
|
If you want to get a count minus the duplicates, copy the table into Excel and do the following.
1. Start in a new column, say E, and give E1 the value 1.
2. Give E2 the formula: IF(E2=E1,0,1)
This sets the value to 1 if it's different than what's above, and 0 if it's a duplicate.
3. Paste this formula for all valid cells in E
4. In another cell, take the entire sum of column E
5. This value should be the current number of teams signed up to at least one event.
I'm pretty sure this is not the most efficient way of doing this. If anyone is quite savvy with Excel, a more direct formula would be appreciated.