Counting text entries

  • Thread starter Thread starter SreeCha
  • Start date Start date
S

SreeCha

I have a list of text entries. I would like to pick up only entries which are
represented more than once and have a count of them also. How do I do this?
Kindly help. Thank you very much.
 
In a helper column:
=COUNTIF(A:A,A1)
Copy down as needed.
Then autofilter for all values greater than 1.
 
Back
Top