Deleting Duplicate Entries

T

TONYC

I have a massive spreadsheet, with data being imported from anothe
application. It has created thousands of duplicate entries. Is there
quick and easy way to delete these duplicate entries?

Help would be most appreciated.

Ton
 
B

bobclark

I have used a macro, easily developed, that first sorts the data into alpha or
whatever you use format, then has a =if(cell=cell above then,1,0) andthen
deletes all the cells with the 1 (meaning duplicate) response.

Just an old 123 response :)

Bob, Used to have a certification that mattered, Clark :)

On Wed, 13 Oct 2004 03:09:06 -0500, in microsoft.public.excel.misc falling into
the bathtub with your monitor, the short circuit caused the following to
mysteriously appear from your keyboard:

~>
~>I have a massive spreadsheet, with data being imported from another
~>application. It has created thousands of duplicate entries. Is there a
~>quick and easy way to delete these duplicate entries?
~>
~>Help would be most appreciated.
~>
~>Tony
 
F

Frank Kabel

Hi
select your data and goto 'Data - Filter - Advanced Filter' and check
'Unique entries only'
 
Top