Counting the occurrence of each entry in a column

[enjam]

Hi all,

I'm trying to develop a macro that will count the occurrence of each entry in a column, and populate a new column with the number of times that entry has appeared in the count.

Attached is a spreadsheet with the highlighted column (column G) showing what I'm trying to automate, and column B is the one I'm trying to perform the count on.

Any help or guidance would be greatly appreciated

VBA Question.xlsx

[Bob Phillips]

Use a simple COUNTIFS

=COUNTIFS($B$2:$B2,$B2)

[enjam]

Brilliant, thanks Bob