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

Hi M,

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

http://www.cpearson.com/excel/duplic...tingDuplicates


---
Regards,
Norman



"mspinella" <u22115@uwe wrote in message news:60a313dcd0279@uwe...
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

"mspinella" <u22115@uwe wrote in message news:60a313dcd0279@uwe...
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.
--
David Biddulph

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

--
Gary's Student


"mspinella" wrote:

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

Thanks Gary's that did the trick



Gary''s Student wrote:
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

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