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
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:=SUM(--(FREQUENCY(IF(MONTH(Table_Data[Month])=MONTH(F$1),MATCH(Table_Data[Name],Table_Data[Name],0)),ROW(Table_Data[Name])-ROW(Table_Data[[#This Row],[Name]])+1)>0))
and dragged across
to be entered with Ctrl+Shift+Enter
Thanks worked a treat
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks