Add a helper column, and a header, with a formula of

=COUNTIF($A$2:A2,A2)1

copied down, and then set criteria of the header and TRUE, and filter using
those criteria.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Malik" wrote in message
...
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