Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using RANK function
I have a list like
product customer revenue revenue year 1 year 2 ..... A cust1 100 110 A cust2 120 65 A cust 3 139 88 ... B cust 1 333 500 B cust 2 122 220 B cust 3 65 287 ... for several years, products and customers What I want to do is get each customer's rank within each product for each year. I will be using this each month and the number of customers within each product class will change from month to month. So, I cannot use somthing like RANK(A23,A15:A90) because the starting and ending rows for a product will change each month. How can I set up the RANK function to pick up the staring and ending points of each product? Thanks Sanford |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rank function | Excel Worksheet Functions | |||
Rank function | Excel Worksheet Functions | |||
Rank Function | Setting up and Configuration of Excel | |||
Rank Function | Excel Worksheet Functions | |||
Rank Function | Excel Discussion (Misc queries) |