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?

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?

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
:-)
"Chip Pearson" wrote:

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?

And the answer is: Landscape orientation!!!

"KG" wrote:

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
:-)
"Chip Pearson" wrote:

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?