how to delete duplicated data

**luuckyoctopus** · 08-03-2012, 05:24 PM

i have 2 files . i copy data from 1st file & paste in 2nd file . some rows r similar now i want to delete them .. any ideas ??

**Ace_XL** · 08-03-2012, 06:01 PM

have you tried

Select your range ....Data--->Remove Duplicates

**FDibbins** · 08-03-2012, 06:35 PM

is the data you copied from the 1st file, below the data in the 2nd file, at the side or on a new sheet?

**luuckyoctopus** · 08-04-2012, 10:48 AM

select range--->data---->remove duplicates .. that will do the job manually what i'm looking 4 is some kind of formula or macro when i paste data duplicated data remove itself automatic .. i paste date below the data so i can manually remove duplicates easily , if there is better automated way to do it but needs to paste beside or in other sheet its ok no problem

**john55** · 08-04-2012, 10:55 AM

see if it helps you

Please Login or Register  to view this content.

**luuckyoctopus** · 08-04-2012, 11:57 AM

it didnt work with me i test it on a file i know well it deleted randomly & after all some duplicated didnt delete also

**john55** · 08-04-2012, 12:02 PM

this is just a test to find duplicates in column F and if there are it ...
(try to adapt it for you, let's say change column F with A)

Please Login or Register  to view this content.

**luuckyoctopus** · 08-04-2012, 01:21 PM

i want to delete duplicated rows , A4 B4 C4 D4 E4 F4 = A9 B9 C9 D9 E4 F4 ....say if A B C D E similar F not similar this is not duplicated 4 me , so in ur code i need to make it from A to F not just changing column

**oeldere** · 08-04-2012, 01:24 PM

try this formula.

Please Login or Register  to view this content.

If the result is True you have an duplicated row.

If the result is False you have 2 unique rows.

**luuckyoctopus** · 08-04-2012, 08:44 PM

i didnt mean A4 A9 that was example to show what i need i have hundreds of duplicated data

**john55** · 08-05-2012, 01:16 AM

you probably do not think about of uploading an example with what you'd like to achive, how yr data looks like after data is added from file 1 to file 2....it should be the best thing you can do at the moment. perhaps someone will give you the right answer.

**oeldere** · 08-05-2012, 06:51 AM

See the example.

It a combination of the given solutions of Oeldere and the VBA code of John55.

Run the macro and see whats happening in collumn K.

For the future i agree with John55; it's better to uplaod an non confidentional example.

Please reply if this is what you're up to.