Ali Enthusiastic self-taught user of MS Excel who's always learning! Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
Re: counting distinct values within different sub-ranges
Thanks AliGW . Those formulas worked. However, when trying to adjust the formula so that it looks at all of column B & C (except B1:C3) i get back #DIV/0! I tried to change the formula to this
Bookmarks