rorybellow
New member
- Joined
- Aug 15, 2017
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I have simplified this for the sake of getting my point across!
I have two sheets
1. contains customer orders across time (all orders)
2. contains customer information.
I want a formula that returns all the products purchased by a customer over time in the 2nd sheet.
Below is an example of a simplified version of the two sheets.
in Sheet 2, next to Jones, I want a formula that returns all the products purchased by Jones. (and then so on for Smith, Doe and Bailey as well)
bonus points if it can exclude duplicates.
so, if the formula worked, in "Products Ordered" on Sheet 2, next to Jones, it would say "blue, yellow, black, green, red"
HELP?????
I have two sheets
1. contains customer orders across time (all orders)
2. contains customer information.
I want a formula that returns all the products purchased by a customer over time in the 2nd sheet.
Below is an example of a simplified version of the two sheets.
in Sheet 2, next to Jones, I want a formula that returns all the products purchased by Jones. (and then so on for Smith, Doe and Bailey as well)
bonus points if it can exclude duplicates.
so, if the formula worked, in "Products Ordered" on Sheet 2, next to Jones, it would say "blue, yellow, black, green, red"
HELP?????
SHEET 1: Orders | ||||
Name | Order Date | Product 1 | Product 2 | Product 3 |
Jones | 8/2/17 | blue | yellow | |
Smith | 8/3/17 | blue | red | purple |
Doe | 8/4/17 | red | green | |
Bailey | 8/5/17 | purple | pink | white |
Jones | 8/6/17 | black | green | red |
Doe | 8/7/17 | gray | brown | |
Bailey | 8/8/17 | yellow | orange | pink |
SHEET 2: Customer Details | ||||
Name | Address | Products Ordered | ||
Jones | ||||
Smith | ||||
Doe | ||||
Bailey |