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?