excelnewbie26
New Member
- Joined
- Oct 25, 2023
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
Hello!
Hope someone can help me with my remaining problem. I have 3 questions that needs to be answered using my raw data (also attached)
1. First problem, i need to get the average days between orders for customers with more than 2 orders.
2. 2nd, to derive the average number of products per customer order.
3. 3rd, to derive the average number of ordered unique products.
I was able to get this using pivot table but i wanted to know how to derive this using formula of AverageIfs or sumproduct
Thank you.
Hope someone can help me with my remaining problem. I have 3 questions that needs to be answered using my raw data (also attached)
Order date | Product number | Customer ID | Order Count | Order Value |
2/21/2021 | 1A | A1 | 1 | 0 |
2/21/2020 | 1A | A2 | 1 | 15.7 |
11/16/2020 | 1A | A3 | 1 | 37.2 |
2/22/2021 | 1B | A3 | 1 | 44.6 |
9/5/2020 | 5657 | A4 | 2 | 78.6 |
1/17/2021 | 78787 | A5 | 1 | 32.5 |
12/3/2020 | 878 | A6 | 1 | 67.7 |
12/10/2020 | 878787 | A6 | 1 | 89.1 |
2/13/2021 | 8787877 | A6 | 1 | 1 |
2/17/2021 | 8787878 | A6 | 2 | 90.1 |
2/17/2021 | 787878 | A6 | 2 | 130 |
1. First problem, i need to get the average days between orders for customers with more than 2 orders.
2. 2nd, to derive the average number of products per customer order.
3. 3rd, to derive the average number of ordered unique products.
I was able to get this using pivot table but i wanted to know how to derive this using formula of AverageIfs or sumproduct
Thank you.