Hello guys,
Been trying for some time to get it right but not getting it though. I know it can be done with pivot table. I need it to be in formula though.
I have duplicates ID in Column E.
I have category VC1, VC2, VC3 in Column A.
I have category Reg1 and Reg2 in Column B.
What I would like to achieve is to get the unique count of ID that matches VC1 and Reg1.
Appreciate in advanced.
Bookmarks