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

http://www.realezsites.com/bus/primitivesoftware

Vaya con Dios,
Chuck, CABGx3



"jsb1107" <u17926@uwe wrote in message news:5ab53c2ebf657@uwe...
Can anyone tell me the easiest way to identify and isolate duplicate
records
found in a spreadsheet column?

See

http://cpearson.com/excel/duplicat.htm


In article <5ab53c2ebf657@uwe, "jsb1107" <u17926@uwe wrote:

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

jsb1107 wrote:
Can anyone tell me the easiest way to identify and isolate duplicate records
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 "false". If it is
a duplicate the formula will return "True"

Get Rid of all of the "Trues"

This will take care of your issue.