Limit list to fields with duplicate info

I

Ivon Yort

I want to do the opposite of what most people ask about in filtering. I want
all single entries to go away. I want my list to display only redundant
values. A plus would be to only have one record displayed for any number of
redundant fields.
 
F

Frank Kabel

Hi
in B1 enter the following formula:
=IF(COUNTIF($A$1:$A$100,A1)=1,"X","")
and copy down

now filter out all 'X' rows
 
D

Debra Dalgleish

If your table is in cells A1:G100, and the duplicates are in column D,
enter the following formula in cell H2:

=IF(COUNTIF($D$1:$D$200,D2)=1,"",IF(COUNTIF($D$1:D2,D2)=1,"X",""))

and copy it down to cell H100

The first record of each duplicate will be marked with an X.
Select a cell in the table, and choose Data>Filter>AutoFilter
From the dropdown list in cell H1, choose "X"
 
Top