Count unique values for a group of criteria

[kimi01]

In the attached example I need a formula to provide the numbers shown in column E.

Basically, how many unique values are there in column B where the month in column A is Jan, Feb, Mar etc?

Forum ExampleApr 3.xlsx

[Fluff13]

How about

Please Login or Register  to view this content.

[kimi01]

Thank you, that worked

[Fluff13]

You're welcome & thanks for the feedback.

[RaulSerg]

Alternatively something like this:

Please Login or Register  to view this content.