Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rank
I have a list of data that I need to rank from 1-?? based on two sets of
criteria. here is an example of what I need. Customer Name Product Sales Rank Customer A Product 1 100 1 Customer A Product 1 50 3 Customer A Product 1 75 2 Customer A Product 2 540 2 Customer A Product 2 390 3 Customer A Product 2 600 1 So my question is, when Product changes, I want the ranking to start over again. Is there a formula I can use to do this? Can I use an if statement combined with a rank? (The product is not a number, it's text) Thank you!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
rank
View the help on the RANK() function. If tie values, which will be ranked
the same, read further down to view the correction formula for tied values in the list. -- Kevin Backmann "Lori Maurer" wrote: I have a list of data that I need to rank from 1-?? based on two sets of criteria. here is an example of what I need. Customer Name Product Sales Rank Customer A Product 1 100 1 Customer A Product 1 50 3 Customer A Product 1 75 2 Customer A Product 2 540 2 Customer A Product 2 390 3 Customer A Product 2 600 1 So my question is, when Product changes, I want the ranking to start over again. Is there a formula I can use to do this? Can I use an if statement combined with a rank? (The product is not a number, it's text) Thank you!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
rank
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank & Group Tournament | Excel Discussion (Misc queries) | |||
RANK Function - Zero Value Ranked as 1 - Should be 10 | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
RANK formula | Excel Discussion (Misc queries) | |||
Rank fx - Fill Down? | Excel Worksheet Functions |