Jebismycopilot
New Member
- Joined
- Apr 27, 2018
- Messages
- 1
Hi everyone,
Can anyone help with this one please? I've got a list of items orders, the columns include the revenue from each item, the order number, and its unique product reference number. In this first piece of work, i have a list of 634 products ordered, that list is made up of 533 unique orders, and there are 54 unique products being sold.
in essence, what i need to do is work out which products are sold together most, and what combinations provide the highest revenues. i'm not very experienced with Macros', but if that's the only way we can do this then i'm happy to give it a go.
The main sticking point here is i need to get this into a template so that a team with less excel can use this on several customers with little intervention from my side.
Let me know if you need any extra info from my side, either way thanks in advance.
Can anyone help with this one please? I've got a list of items orders, the columns include the revenue from each item, the order number, and its unique product reference number. In this first piece of work, i have a list of 634 products ordered, that list is made up of 533 unique orders, and there are 54 unique products being sold.
in essence, what i need to do is work out which products are sold together most, and what combinations provide the highest revenues. i'm not very experienced with Macros', but if that's the only way we can do this then i'm happy to give it a go.
The main sticking point here is i need to get this into a template so that a team with less excel can use this on several customers with little intervention from my side.
Let me know if you need any extra info from my side, either way thanks in advance.
