Copying data to excel and deleting duplicates

D

Dom

Hi

Not sure if this is possible but i have created a spreadsheet with data that
i want to keep adding to. But the data that I will be copying over and adding
will have a lot of info that is already on my spreadsheet. What I want to do
is to be able to only copy across the new information without having to go
through each individually. And i wasnt sure if there was any way of excel
deleting the duplicate info?

Any suggestions or help would be fantastic

Thanks a lot
 
S

Soundar

Hi,

You can solve this problem by using Advanced Filter option in Excel.

For example

A (Column)

Name
a
c
a
e
a
d
a
e

Just click on the label (in the above example it is Name (Cell A1), And then
click

Data--> Advanced Filter --> And then click the check box, Unique records
only check box. And also give the cell address in which you want to display
the unique records (Copy to option in dialog box, example B1).

Then you will get the following output

A B
name name
a a
c c
a e
e d
a
d
a
e


Hope this will clear your doubt.

Regards,
Soundar
 
Top