Say your duplicated KEYS are in column A. Enter formula =COUNTIF($A:$A,A2)1
in a helper column, fill it down until your last row, and Autofilter helper
column to TRUE!

Regards,
Stefi

€žMalik€� ezt Ã*rta:

I have 40K rows of data....some data is unique while some is
duplicated,..occuring at least twice...I want to get only the duplicated
data....how do i filter it? Unique records give ALL of the unique data. I
need just the data that is being repeated. Pls help. Thanks