Help with filtering problem

[mspinella]

I have one column of text values. I want to extract only those values that
appear more than once in the column. Any ideas?

Thanks

 

[Norman Jones]

Hi M,

Hi see Chip Pearson's Duplicates page for various techniques:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[David Biddulph]

I have one column of text values. I want to extract only those values
that
appear more than once in the column. Any ideas?

You could try a helper column with =COUNTIF(A$1:A$nnn,A1) copied down that
column, and filter on values >1 in there.

 

[Gary''s Student]

One way is a Pivot Table:

1. make sure there is a header cell on top of the column, i.e. ITEMS
2. create the Table with ITEMS in the row area and Count of ITEMS in the
data area

This will result in a table in which each item appears only once with the
count next to it.

Click on the cell directly above the pivot table and switch on autofilter.
Using the Total pull-down, select:
custom > greater than 1

 

[mspinella]

Thanks Gary's that did the trick

One way is a Pivot Table:

1. make sure there is a header cell on top of the column, i.e. ITEMS
2. create the Table with ITEMS in the row area and Count of ITEMS in the
data area

This will result in a table in which each item appears only once with the
count next to it.

Click on the cell directly above the pivot table and switch on autofilter.
Using the Total pull-down, select:
custom > greater than 1