How can I removed duplicate cells from rows?
I've exported a list of email address but the duplicate is not always in the same column.
So I want to move the 2nd instance of email address further along the row....
Screenshot 2019-12-10 at 19.29.50.png
if I can shift the cells across after deletion that would be handy too but not essential.
Hi, will my solution work for you?
The results are in sheet 2.
Look in the attachment.HTML Code:
Best Regards,
Maras.
That's exactly the result I'm looking for many thanks. Apologies I shortened the csv to make it easier to explain, I do have other columns so I've attached the actual csv and put in a dummy line for an example. Not sure if it makes difference to your code?
Data will go from a2 to o555
Hi, it works on your data from the last attachment.HTML Code:
It's put data in sheet2 but has only added column A and none of the others.
Add attachment with my code to show results.
Everything works very well on my computer. I don't know if you copied the code correctly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks