Forum Discussion
Creating a list of products sold together with a selected product
Hi, I have a dataset which includes i.a. orders numbers and names of products. Let's assume it looks like this: Order No. Product 1 A 2 A 2 B 2 C 3 A 3 B 4 A 4 B...
MJezierski1050 Hi,
You may achieve your desired result by applying combination of formulas & pivot table. By selecting any product in cell 'B1', all associated products along with order no. and main product will appear as below table.
Since pivot option is used, you need to refresh data after every selection.
Also ensure that only 'blank' value is unchecked and rest of the values (order no.) are always marked as checked.
A sample file is also attached for your reference, hope it will help you.
Please let me know if it works for you.
Thanks
Tauqeer