Forum Discussion
Ranking Cells
This is a little tricky. I would add some helper columns for each position to help track. You'll have to change the columns around but something like this should work.
In the helper columns:
=IF($O195=P$193,1+COUNT(P$194:P194),"")
It'll count each occurrence and rank them in order. From there, you'll need to do another xlookup for each player like in your previous question.
Let me know if you can work this to fit your workbook or if you need more explanation!
This is a little tricky. I would add some helper columns for each position to help track. You'll have to change the columns around but something like this should work.
In the helper columns:
=IF($O195=P$193,1+COUNT(P$194:P194),"")
It'll count each occurrence and rank them in order. From there, you'll need to do another xlookup for each player like in your previous question.
Let me know if you can work this to fit your workbook or if you need more explanation!