Padraig O'Dea
asked on
Excel - Duplicate values in columns
Hi folks,
I have a shop where customer buy products.
My spreadsheet shows the products they buy BUT these products are duplicated.
See the yellow section of my spreadsheet. THis is the result I require - (duplicates removed).
How do I do this ?
(In my real life situation I have 24 columns)
Thanks as always,
EE_DUpes_Channels.xlsx
I have a shop where customer buy products.
My spreadsheet shows the products they buy BUT these products are duplicated.
See the yellow section of my spreadsheet. THis is the result I require - (duplicates removed).
How do I do this ?
(In my real life situation I have 24 columns)
Thanks as always,
EE_DUpes_Channels.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Top class solution.
I tweaked it a little for my own need ans it worked perfectly.
I tweaked it a little for my own need ans it worked perfectly.
Glad it worked as per your requirement.
Thanks for the feedback.
Thanks for the feedback.
You need to create dependent drop-down list for each sub category of your products, see here Making a cascading (dependent) Excel drop down list