Duplicate Data

[KB]

How do you identify and delete duplicated data lines in Excel aside from sorting and manually deleting duplicated lines?

 

[Max]

Try MVP Chip Pearson's page at:

http://www.cpearson.com/excel/deleting.htm

Look for the macro DeleteDuplicateRows

--
hth
Max
-----------------------------------------
Please reply in thread
Use xdemechanik <at>yahoo<dot>com for email
--------------------------------------------------------

How do you identify and delete duplicated data lines in Excel aside from

sorting and manually deleting duplicated lines?