Unique Count Formula

Hi

Anyone know a formula I can put in the yellow cells so I can remove the pivot table unique count?

Just need to count the unique heads per month based on the data table on the left.

Thanks

The array formula in F2:

Formula:

Please Login or Register  to view this content.

and dragged across

to be entered with Ctrl+Shift+Enter

Thanks worked a treat

Originally Posted by benoj2005

Thanks worked a treat

Thanks for the feedback!