Hi,
I have a list of names in column A, many occurring more than once.
Can someone please suggest the VBA code that will inspect the data in column A and then copy a single instance of each name into column C, starting at C2.
Thanks!
Hi,
I have a list of names in column A, many occurring more than once.
Can someone please suggest the VBA code that will inspect the data in column A and then copy a single instance of each name into column C, starting at C2.
Thanks!
Last edited by andrewc; 11-01-2013 at 04:49 AM.
You can use Excel's built-in functions, such as "Advanced filter" and PT
Hi
Try this code.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks, AB33.
If I were to want to use VBA to achieve such a thing, could you possibly suggest how to do this?
Thanks
Ignore my last post - Fotis has kindly suppiled an answer
Thanks very much
You are welcome and thanks for the feedback.
In fact this code use Advanced Filter as AB33 suggested!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks