Thread: Duplicate sorts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Malik Malik is offline
external usenet poster
 
Posts: 47
Default Duplicate sorts

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