software

I would like to search an Excel db spreadsheet including name, company,
address, phone, e-mail address in rows. I want to locate and be able to
extract the duplicates, not necessarily delete or remove the duplicate
records.

Can anyone help. The quot;Delete duplicate rowsquot; and quot;How to remove duplicate
recordsquot; is not the answer.

I remember seeing training on this subject a few months ago but cannot find
it now.

Thanks
Wayne

www.cpearson.com/excel/duplicat.htm

--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Waynequot; gt; wrote in message
...
gt;I would like to search an Excel db spreadsheet including name, company,
gt; address, phone, e-mail address in rows. I want to locate and be able to
gt; extract the duplicates, not necessarily delete or remove the duplicate
gt; records.
gt;
gt; Can anyone help. The quot;Delete duplicate rowsquot; and quot;How to remove duplicate
gt; recordsquot; is not the answer.
gt;
gt; I remember seeing training on this subject a few months ago but cannot
gt; find
gt; it now.
gt;
gt; Thanks
gt; Wayne