jamesg
11-05-2011, 11:01 PM
Can someone help with a formula please?
I have a pivot table of customers (biggest to smallest) and Products (biggest to smallest, within the customers)
I want to generate a sequence number I can Vlookup against that has 2 aspects to it. A whole number ranks the customer (eg 1, 2, 3, 4 etc) and decimal ranks a product (.1, .2, .3, .4 etc) within the customers sales. eg 1.2 = No 1 customers No. 2 product, 7.18 = 7th ranked Customers 18th ranked product etc, etc.
Many thanks, any help is appreciated.
James
I have a pivot table of customers (biggest to smallest) and Products (biggest to smallest, within the customers)
I want to generate a sequence number I can Vlookup against that has 2 aspects to it. A whole number ranks the customer (eg 1, 2, 3, 4 etc) and decimal ranks a product (.1, .2, .3, .4 etc) within the customers sales. eg 1.2 = No 1 customers No. 2 product, 7.18 = 7th ranked Customers 18th ranked product etc, etc.
Many thanks, any help is appreciated.
James