RANK formula

[Guest]

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?

 

[Chip Pearson]

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

 

[Guest]

Looks like the ticket and I thank you! Your webpage is wider than most and
some of the text on the right margin gets cut off when I try to print the
instructions. I'm still looking for a solution to this little nagging problem

 

[Guest]

And the answer is: Landscape orientation!!!

Looks like the ticket and I thank you! Your webpage is wider than most and
some of the text on the right margin gets cut off when I try to print the
instructions. I'm still looking for a solution to this little nagging problem