#### matt-gilbert

##### Member

My data in column A has duplicates. I am trying to write a formula in column B to identify the occurence number count of each duplicate. Desired results as follows;

A B

Red 1

Yellow 1

Green 1

Yellow 2

Blue 1

Red 2

Yellow 3

I thought this was going to be simple however I have been searching internet for over an hour now and all I can find are formulas which give me a total count of duplicates. Thanks in advance.

Matt