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

Luke M
*Remember to click "yes" if this post helped you!*


"SreeCha" wrote:

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