Counting text entries

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.
 
L

Luke M

In a helper column:
=COUNTIF(A:A,A1)
Copy down as needed.
Then autofilter for all values greater than 1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recover Outlook calendar entry 1
Office365 Family + TXT or MX Domain 0
How can the font and size of (all) citation numbers be altered? 1
Counting unique instances of a text string 2
Section and Page numbering 0
Automatic indexing in footnotes - solved 0
Space at end of multi page list to accommodate new entries 1
Function in Excel to count and list number of entries of text valuesin a row. 2

Top