See the Unique Ranks section at
http://www.cpearson.com/excel/rank.htm .


"KG" wrote in message
...
I have a large data set representing customers, the products
they buy, and
their total $ sales. I want to extract the complete records of
customers who,
say rank, number 2 in sales. I have set the extraction up
through VBA but
unfortunately I'm dependent on the RANK formula which has a
shortcoming:

if sales of $80,000 represent a #2 rank and there are 4
customers with sales
of $80,000, the RANK formula does not assign a #3, #4 and #5
ranking.

Is there another Excel formula or a technique to get around
this?