Hello All,

Teethless Mama helped me with formula yesterday.

Can someone translate/breakdown the formula please? See below

Thank you all!
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