Urgent!

[kriger]

hi,
how do i delete rows that contains same multiple entries for example
Cardeira Sergio Lisbon
Cardeira Sergio Lisbon

i know how to do it manually but i have to go through 4000 rows and its a long lengthy method and my eyes hurt if theres a faster way of doing it please lemme know i thank you in advance.

 

[Von Pookie]

One example:
http://www.mrexcel.com/board2/viewtopic.php?t=230444&highlight=advanced+filter

You can also search the board for deleting duplicates.

 

[SteveO59L]

Concatenate your entries, to provide a unique identifier, then use AutoFilter, with the "Copy to another Location" and "Unique Identifier" options.

p.s You will need to copy, paste special values on your concatenated values

 

[SteveO59L]

Alternatively, you could use something like


=COUNTIF($D$1:D1,D1)


copied through your range, then filter on >1 values.