Dear everyone;
I am trying to create a ranking of clubs, but I only want to rank clubs that satisfy one Criteria
- Column A = Club number
- Column B = YES or NO (fit criteria)
- Column C = Club score (points from 0 to 1500)
- Column D = Raking (if col B = Yes)
I tried using the Rank function, but could not tweak to only rank based on Col B = Yes;
Would anyone know of a solution ?
Thank you so much for taking the time to look into it.
attached: a simplified example of what I am trying to do.
Bookmarks