Counting names in a list

[ChIpStIcK]

Hi, this feels like it should be easy but I can't work it out so have resorted to begging:

I have a column of random names, say 200 of them in column A. I want to have column D show a name if (and only if) it appears more than once and have a count of how many times it appears in column E.

I can't use vba. Please help!

 

[Aladin Akyurek]

Mind pasting me your second line of copy downs? Cant get it to show anything but the first dupe name and I can't work out what I should be changing for each line.

Does the range housing names change frequently?

 

[T. Valko]

Mind pasting me your second line of copy downs? Cant get it to show anything but the first dupe name and I can't work out what I should be changing for each line.

I can post a sample file if you'd like.

 

[ChIpStIcK]

Ignore me, I've got it working now. Mass thanks.

 

[T. Valko]

Ignore me, I've got it working now. Mass thanks.

Good deal. Thanks for the feedback!