ExcelBanter - Numeric Rank By Qty Sold

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Numeric Rank By Qty Sold (https://www.excelbanter.com/excel-discussion-misc-queries/131911-numeric-rank-qty-sold.html)

JeremyH1982

Numeric Rank By Qty Sold

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??

--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com

T. Valko

Numeric Rank By Qty Sold

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

"JeremyH1982" wrote in message
...
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??

--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com

JeremyH1982

Numeric Rank By Qty Sold

that worked...

thanks.

--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com

T. Valko

Numeric Rank By Qty Sold

You're welcome. Thanks for the feedback!

Biff

"JeremyH1982" wrote in message
...
that worked...

thanks.

--
Jeremy Himmelreich
Computer IT Manager
http://home.comcast.net/~jeremy1982
http://www.willitshoe.com

All times are GMT +1. The time now is 11:27 AM.