Hi,
I have spreadsheet that contains values in various columns (and may include blank cells) and I was wondering if you can help:
1. Remove duplicates from all the columns
2. Copy all the cells into one column
3. Once again check for any duplicates
4. Sort the cells in ascending order
I have attached a sample spreadsheet for your reference.
Note: I am assuming I would require a macro, but if there is any alternative that would work, please do let me.
Thanks in advance,
Streetcat
Last edited by streetcat; 01-25-2012 at 02:33 AM.
Can someone please help me?
Please provide any variation that may work for my problem.
All I require is to remove duplicates and sort the cells in ascending order
This macro will examine columns A:C and assemble a unique list for you in column G:
Please Login or Register to view this content.
Last edited by JBeaucaire; 01-23-2012 at 03:58 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This macro will examine columns A:C and assemble a unique list for you in column G:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks