Urgent!

kriger

New Member
Joined
Sep 18, 2006
Messages
1
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.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Alternatively, you could use something like


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


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

Watch MrExcel Video

Forum statistics

Threads
1,112,885
Messages
5,543,033
Members
410,583
Latest member
gazz57
Top