find dupes and hide non dupes

joeloveszoe

Board Regular
Joined
Apr 24, 2014
Messages
52
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>
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,508
Office Version
  1. 365
Platform
  1. Windows
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:
Code:
=IF(COUNTIF(A:A,A2)>1,"DUPE","NOT")
and copy down for all rows.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,508
Office Version
  1. 365
Platform
  1. Windows
You are welcome. Glad I was able to help!:)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,450
Messages
5,528,818
Members
409,838
Latest member
Cowells01
Top