Hi
I'm struggling with a formula or VBA which can return an answer for this statement.
"Given a set of transactions, a set of returning customers and a set of products they purchase, what percentage of products on their transactions always stay the same"
e.g. if Customer X buys 10 products from us, X times a month, and on each transaction there is always the same 5 products, then 50% of the products they purchase stay the same.
I need to get to this percentage on 1000s of rows of data across 1000s of customers and on 1000s of products.
Is this possible?
Thanks!
Bookmarks