LinkBack URL
About LinkBacks
omaral 
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
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.
If it is 2003 and the data size is huge then consider Pivot Table also
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks