Remove duplicate entries in Excel

ray_gillespie

Moderator
Staff member
Political User
#1
Hi,
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! :)
 

Khayman

I'm sorry Hal...
Political User
#2
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 https://tinyurl.com/ycpxl
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 ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,970
Messages
673,297
Members
89,016
Latest member
Poseeut