Duplicate sorts
thanks everyone fr help.....
"Lori" wrote:
After showing unique data with Advanced Filter, you can invert the selection
to show just duplicated data. Select the data range then press (or select):
1. Alt+; (Edit Goto Special Visible Cells)
2. Alt+DFS (Data Filter Show All)
3. Ctrl+9 (Format Rows Hide)
You can then select data then Alt+; again and copy to a new sheet.
To show all data again select all cells and unhide rows.
(This method can be used to invert any filtered selection.)
"Malik" wrote:
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
|