Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
top ten customers by transaction count by product
I have a data dump. each row represents a single transation for a product by
a customer. There are 15 products represented in the data dump. So product 1 could have 100+ transactions/rows by customer A. And custmer A could have bought all 15 products in multiple transactions. I would like to be able to display the top ten customers for each of my product groups. Does this make sense? An example fo the data: Prod1 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod3 customer1 08/01/2001 Prod4 customer1 08/01/2001 Prod1 customer1 08/01/2001 Prod1 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod3 customer1 08/01/2001 Prod4 customer1 08/01/2001 Prod1 customer2 08/01/2001 Prod1 customer2 08/01/2001 Prod1 customer3 08/01/2001 So the report would look like this Prod1 Cust1 3 Prod1 Cust2 2 Prod1 Cust3 1 Prod2 Cust1 3 Prod3 Cust1 2 Prod4 Cust1 2 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
top ten customers by transaction count by product
I had a similar problem a while ago. Do a search for "top 25" and you'll
find a whole lot of help I received on this issue. I was able to completely solve the issue with these comments. HTH "Carl" wrote: I have a data dump. each row represents a single transation for a product by a customer. There are 15 products represented in the data dump. So product 1 could have 100+ transactions/rows by customer A. And custmer A could have bought all 15 products in multiple transactions. I would like to be able to display the top ten customers for each of my product groups. Does this make sense? An example fo the data: Prod1 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod3 customer1 08/01/2001 Prod4 customer1 08/01/2001 Prod1 customer1 08/01/2001 Prod1 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod3 customer1 08/01/2001 Prod4 customer1 08/01/2001 Prod1 customer2 08/01/2001 Prod1 customer2 08/01/2001 Prod1 customer3 08/01/2001 So the report would look like this Prod1 Cust1 3 Prod1 Cust2 2 Prod1 Cust3 1 Prod2 Cust1 3 Prod3 Cust1 2 Prod4 Cust1 2 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
top ten customers by transaction count by product
Thanks!
"JBoulton" wrote: I had a similar problem a while ago. Do a search for "top 25" and you'll find a whole lot of help I received on this issue. I was able to completely solve the issue with these comments. HTH "Carl" wrote: I have a data dump. each row represents a single transation for a product by a customer. There are 15 products represented in the data dump. So product 1 could have 100+ transactions/rows by customer A. And custmer A could have bought all 15 products in multiple transactions. I would like to be able to display the top ten customers for each of my product groups. Does this make sense? An example fo the data: Prod1 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod3 customer1 08/01/2001 Prod4 customer1 08/01/2001 Prod1 customer1 08/01/2001 Prod1 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod2 customer1 08/01/2001 Prod3 customer1 08/01/2001 Prod4 customer1 08/01/2001 Prod1 customer2 08/01/2001 Prod1 customer2 08/01/2001 Prod1 customer3 08/01/2001 So the report would look like this Prod1 Cust1 3 Prod1 Cust2 2 Prod1 Cust3 1 Prod2 Cust1 3 Prod3 Cust1 2 Prod4 Cust1 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet linkage | Excel Discussion (Misc queries) | |||
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
filter on pivot table | Excel Discussion (Misc queries) | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
formula needed | New Users to Excel |