Is there a way to rank names based on a subcategory? And within the subcategory is there a way to rank those players as well.
For example,
I want to rank the following 5 subcategories in order based on rank and position. So for Rank 1, it would say C1, rank 2 it would say SP1, rank 3 would say C2, rank 4 would say C3 and rank 5 would say SP2.
COL........A.,,...........B
RW.......Rank........Subcat
1...........1...............C
2...........2..............SP
3...........3...............C
4...........4...............C
5...........5,.............SP
Thanks!
Bookmarks