![]() Make sure you pay close attention to your dollar signs at the beginning of the COUNTIF function. ![]() I won’t go into the details of how this formula works (if interested go here), just know if you set it up properly it will magically work. The downside to using an Array formula over an Dynamic Array function is you have to carry it down manually, there is no Spill Range functionality that will automatically resize your list. The formula I will share in this post does not require keying in Ctrl+Shift+Enter to activate it, hence why I prefer it. Pretty much all of these methods involved using array formulas (think Ctrl+Shift+Enter) to output the end result. Before the UNIQUE function was released, Excel users were left using more complex methods to compile a list of unique values from a range.
0 Comments
Leave a Reply. |