software

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:

www.cpearson.com/excel/duplic...tingDuplicates---
Regards,
Norman
quot;mspinellaquot; lt;u22115@uwegt; wrote in message news:60a313dcd0279@uwe...
gt;I have one column of text values. I want to extract only those values
gt;that
gt; appear more than once in the column. Any ideas?
gt;
gt; Thanks
quot;mspinellaquot; lt;u22115@uwegt; wrote in message news:60a313dcd0279@uwe...
gt;I have one column of text values. I want to extract only those values
gt;that
gt; 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 gt;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 gt; greater than 1

--
Gary's Studentquot;mspinellaquot; wrote:

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

Thanks Gary's that did the trick
Gary''s Student wrote:
gt;One way is a Pivot Table:
gt;
gt;1. make sure there is a header cell on top of the column, i.e. ITEMS
gt;2. create the Table with ITEMS in the row area and Count of ITEMS in the
gt;data area
gt;
gt;This will result in a table in which each item appears only once with the
gt;count next to it.
gt;
gt;Click on the cell directly above the pivot table and switch on autofilter.
gt;Using the Total pull-down, select:
gt;custom gt; greater than 1
gt;
gt;gt; I have one column of text values. I want to extract only those values that
gt;gt; appear more than once in the column. Any ideas?
gt;gt;
gt;gt; Thanks