Ok if I were to use the COUNTIF. How would I do that?
Example below. Yeah the problem with RANK is that in the 3rd column where I
want to list the fruits by descending order based on the tally, 25 is for
banana and apple but it will just list banana 2 times. Some help with the
formula for COUNTIF please :)
Fruit Tally
banana 25
carrot 23
fig 24
apple 25
orange 19
peach 1

"Bernd P" wrote:

Hello,

If you like to sort with worksheet functions:
http://www.sulprobil.com/html/sorting.html

I would also suggest to use the COUNTIF() + COUNTIF() formula approach
instead of RANK because you might face identical sort keys or (in
other tasks) non-numerical sort keys for which RANK would not work.

Regards,
Bernd