Good Afternoon,
I was helped this morning by some amazing forum members but I now have another variable I would like to add to the array I was helped with. The attached has the formula so far (column S - 'Active Customers') but I would like to expand that formula to also include a unique count of customers, but keeping the existing rules in that formula that are working a treat.
Thank you very much in advance, again.
I wonder if you can tell us what the formula in column S is supposed to be doing? I think it can be simplified significantly.
Try this array formula** for the count of unique customers. Array entered in T2 and copied down:
=SUM(IF(FREQUENCY(IF(D$2:D$20=D2,IF(O$2:O$20=O2,MATCH(F$2:F$20,F$2:F$20,0))),ROW(F$2:F$20)-ROW(F$2)+1),1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
I'm assuming no empty cells in column F.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Perfection! Thank you soooooo much, Tony.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks