Numeric Rank By Qty Sold

J

JeremyH1982

Hello again...

I have a spreadsheet, in Column A, I have the Rank... which I manually type
in...
In Column C I have the Qty Sold...

How do I get the rank to be automated??
 
T

T. Valko

Try this:

For highest = rank 1

=RANK(C1,C$1:C$10)

For lowest = rank 1

=RANK(C1,C$1:C$10,1)

Copy down as needed

Biff
 
Top