finding redundant data

[eternal_cat via OfficeKB.com]

how can i see if i have two records in my spreadsheet that are the same? I
have over 60,000 rows of data.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200512/1

[Max]

One way ..

Assuming the key col is col A, with data in A2 down

Use an empty col to the right, say col E
Put in E2: =IF(A2="","",IF(COUNTIF($A$2:A2,A2)>1,"x",1))
Copy E2 down to last row of data in col A

Col E will return a "1" for the 1st instances of data in col A,
"x" for any duplicates thereafter

Do a Data > Filter > Autofilter on col E
To see/filter out the duplicates,
select "x" from the autofilter droplist in E1
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"eternal_cat via OfficeKB.com" <u14645@uwe> wrote in message
news:5883f36879898@uwe...
> how can i see if i have two records in my spreadsheet that are the same? I
> have over 60,000 rows of data.
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200512/1