View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Help with filtering problem

"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