software

Can anyone tell me the easiest way to identify and isolate duplicate records
found in a spreadsheet column?

I use Jim Cone's fine commercial Add-in called XL Companion for things like
this.......it's available at

www.realezsites.com/bus/primitivesoftware

Vaya con Dios,
Chuck, CABGx3
quot;jsb1107quot; lt;u17926@uwegt; wrote in message news:5ab53c2ebf657@uwe...
gt; Can anyone tell me the easiest way to identify and isolate duplicate
records
gt; found in a spreadsheet column?
See

cpearson.com/excel/duplicat.htmIn article lt;5ab53c2ebf657@uwegt;, quot;jsb1107quot; lt;u17926@uwegt; wrote:

gt; Can anyone tell me the easiest way to identify and isolate duplicate records
gt; found in a spreadsheet column?


jsb1107 wrote:
gt; Can anyone tell me the easiest way to identify and isolate duplicate records
gt; found in a spreadsheet column?
First sort your records

Insert an additional column

In the blank column add this formual.=(b1=b2) Then paste to the end of the data.This will match the top line of the data to the next line of the data.
If it is not a duplicate it the formula will return quot;falsequot;. If it is
a duplicate the formula will return quot;Truequot;

Get Rid of all of the quot;Truesquot;

This will take care of your issue.