Early this morning I asked a question (which I marked as SOLVED) about “combining 2 formulas” and sktneer suggested a good sumproduct array formula to use, which worked perfectly. I was experimenting with another scenario using the same formula but for some strange reason it is only working 99%. Please see attachment.
Using your posted workbook, this regular formula returns the count of unique Col_B items for each Col_A value
Copy that formula down as far as you need.
Please Login or Register to view this content.
Does that help?
Thanks Ron, that works on both of my scenarios...Out of curiosity do you know why the sumproduct formula did not work?
Yes...
The MATCH function's 3rd argument is missing. Consequently, Excel assumes 1 (approximate match)
BTW...When you're using an array formula, SUMPRODUCT is unnecessary. SUM will suffice.
This array formula, completed by holding down CTRL+SHIFT+ENTER works:
However, why use an array formula when you can use a regular formula?Please Login or Register to view this content.
(Besides, nobody I work with ever remembers to C+S+E an array formula after they edit it)
Thanks for the explanation and help...will practice now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks