J
jsb1107
Can anyone tell me the easiest way to identify and isolate duplicate records
found in a spreadsheet column?
found in a spreadsheet column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
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
this.......it's available at
http://www.realezsites.com/bus/primitivesoftware
Vaya con Dios,
Chuck, CABGx3
J
JE McGimpsey
P
patricklcarroll
jsb1107 said: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.