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>

PFX40143-BULK

PFX40144-BULK

PFX40482-BULK

PFX40482-BULK

PFX40516-BULK

PFX40516-BULK

PFX40518-BULK

PFX40518-BULK

PFX40523-BULK

PFX40526-BULK

PFX40527-BULK

PFX40528-BULK

<tbody>
</tbody>

 

[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!