Visit Chip's site http://www.cpearson.com/excel/Duplicates.aspx where there
is lots about duplicates
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Martha" wrote in message
...
How do i get rid of duplicate entries in a spreadsheet?