R Rodger Member Sep 17, 2022 #1 I am trying something new, and need help. I have Column C with a YTD total. Is it possible to have Column A rank the players, IE: 1, 2, 3-T, 3-T, (if they have the same total), 4, etc
I am trying something new, and need help. I have Column C with a YTD total. Is it possible to have Column A rank the players, IE: 1, 2, 3-T, 3-T, (if they have the same total), 4, etc
R Rodger Member Nov 15, 2022 #3 Thank you so much, this works, but ... This ranks them 1,1,1 4.4,6 etc. Is it possible that they are ranked 1,1,1,2,2,3, etc? I hope that makes sense ... Rodger
Thank you so much, this works, but ... This ranks them 1,1,1 4.4,6 etc. Is it possible that they are ranked 1,1,1,2,2,3, etc? I hope that makes sense ... Rodger
P Peter Bartholomew Well-Known Member Nov 15, 2022 #4 This is 365 only, and already getting heavy Code: = LET( distinct, UNIQUE(total), group, MAP(distinct, LAMBDA(d, COUNT(IF(distinct<=d,1)))), XLOOKUP(total, distinct, group) ) If you insist on adding "-T" for ties, it can only get worse Code: = LET( distinct, UNIQUE(total), group, MAP(distinct, LAMBDA(d, COUNT(IF(distinct<=d,1)))), rank, XLOOKUP(total, distinct, group), suffix, IF(COUNTIFS(total,total)>1, "-T", ""), rank & suffix )
This is 365 only, and already getting heavy Code: = LET( distinct, UNIQUE(total), group, MAP(distinct, LAMBDA(d, COUNT(IF(distinct<=d,1)))), XLOOKUP(total, distinct, group) ) If you insist on adding "-T" for ties, it can only get worse Code: = LET( distinct, UNIQUE(total), group, MAP(distinct, LAMBDA(d, COUNT(IF(distinct<=d,1)))), rank, XLOOKUP(total, distinct, group), suffix, IF(COUNTIFS(total,total)>1, "-T", ""), rank & suffix )
p45cal Well-Known Member Nov 16, 2022 #5 Peter Bartholomew said: If you insist on adding "-T" for ties, it can only get worse Click to expand...
Peter Bartholomew said: If you insist on adding "-T" for ties, it can only get worse Click to expand...