Finding duplicate records
Thank you
"Teethless mama" wrote:
In B1: =COUNTIF($A$1:A1,A1)1
Copy down as far as needed.
AutoFilter the TRUE value, then go to Edit Delete
"Susan" wrote:
Hello All,
Have 10 columns of data for each row(record). Dates, serial numbers, dollar
amts.
Sometimes a serial number is keyed twice. What is the best way to find if
there are duplicate serial numbers after keying about 500 records? Is there a
way to prevent?
Using Excel 2002.
Many thanks to all!
Susan
|