I have a data set with groups of 40 rows. I need to rank 1-40 in each set
for charting order by amount. In some cases amounts are all the same or
some are. I still need to order 1-40 without any skips or duplicates. I can
write a process that does this but thought there was a function for it.
Rank and Dense Rank don't work because you get duplicate ranks when amount
is the same. Maybe doesn't exist. Just checking.
Thanks,
Ethan Post
FarmPulse360.com