Hi
I have 1100+ products but due to the spread sheet listing each product variation as a separate row there are 120,000+ rows. I need to run a quick Macro that takes the style # or product name and compares all the other columns and deletes any duplicate values leaving all unique values separated with "|" (no space necessary).
Attached is a sample... with the demonstrated result on sheet two.
Sample Data.xlsx
Thank you for your help in advance!
Hi 65monroe,
Welcome to the forum!!
As you're using at least Excel 2007 (or later), you don't need a macro as the capability to do this exists in those versions. To do this, follow these four steps:
1. Select the entire dataset (A1:P33 in your posted example)
2. From the Data Tools tab within the Data ribbon click Remove Duplicates
3. Click the Unselect All button from the Remove Duplicates dialog and then click the Style# option
4. Click OK
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hi
Here goes
rylo
Please Login or Register to view this content.
as an option
Please Login or Register to view this content.
Thank you Both!
Nilem & Rylo both solutions accomplished the final goal. I really appreciate your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks