find dupes and hide non dupes

[joeloveszoe]

hi
i have a spreadsheet with several thousand rows. i know how to find dupes (through conditional formatting) - but i don't know how to filter to only show the dupes
is there a way someone can share with me?
thanks so much =)

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica; color: #942193}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 0.8px 0.8px 0.8px 0.8px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]PFX40143-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40144-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40482-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40482-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40516-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40516-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40518-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40518-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40523-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40526-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40527-BULK
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX40528-BULK
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

You can create a "helper" column where you identify the dupes and filter on that.
For example, if your data is in column A, and your first row with data is cell A2, place this formula in B2:

=IF(COUNTIF(A:A,A2)>1,"DUPE","NOT")

and copy down for all rows.

 

[joeloveszoe]

that genius!!! i love a helper column
thanks sooo much
yay =)

 

[Joe4]

You are welcome. Glad I was able to help!