LinkBack URL
About LinkBacks
Got a huge dataset with a list of non-repeating names. For example, among the dataset is about 1,500 names that dont repeat itself in a column. How can I isolate just that list of non-repeating names from that huge dataset?
Got a huge dataset with a list of non-repeating names. For example, among the dataset is about 1,500 names that dont repeat itself in a column. How can I isolate just that list of non-repeating names from that huge dataset?
What is your exact excel version?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi and welcome to the forum
If you have 2007 or later (I know your profile says 2003, but maybe you did not update it yet?) 1 quick way is to copy the full list of names to another column, then use Data/Remove Duplicates.
If you dont have 2007, and/or if this will be a repeated process, provide a sample of your data and I will use a formula to do that for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If it is 2003 and the data size is huge then consider Pivot Table also
Originally Posted by :) Sixthsense :)
My excel version is 2010.Hi and welcome to the forum
If you have 2007 or later (I know your profile says 2003, but maybe you did not update it yet?) 1 quick way is to copy the full list of names to another column, then use Data/Remove Duplicates.
If you dont have 2007, and/or if this will be a repeated process, provide a sample of your data and I will use a formula to do that for you
Last edited by omaral; 03-05-2014 at 09:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks