Remove duplicate entries in Excel


Staff member
Political User
I've got an excel spreadsheet full of data that I have compiled from 3 other spreadsheets. A lot of the data in these spreadsheets are present in all 3, so now the one large file I have contains duplications of certain lines.
Is there anyway to run some sort ot batch process or script that will remove any extra instances of every row of data other than the first occurance of the data in that row?
Thanks in advance! :)


I'm sorry Hal...
Political User
Highlight the columns, go to data->filter->advanced filter -> tick "unique records only" then with filter inplace or copy to a new location. then you done

Members online

No members online now.

Latest posts

Latest profile posts

Perris Calderon wrote on Electronic Punk's profile.
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
What a long strange trip it's been. =)

Forum statistics

Latest member