| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numeric Rank By Qty Sold
that worked...
thanks. -- Jeremy Himmelreich Computer IT Manager http://home.comcast.net/~jeremy1982 http://www.willitshoe.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| keep track of gift certificates sold | New Users to Excel | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
| Need formula to count number of books sold | Excel Worksheet Functions | |||
Hybrid Mode
