Forum Discussion
Solved
Warning in Excel when trying to use dynamic array
Hi there, I did a search on this before posting, but no luck yet. Consequently, if this has already been answered, please point me there. With that said, I am a "seasoned" user of Excel (aka old), a...
Here's a solution (not double-checked) using several Dynamic Array functions.
Oops, was going to include link to documentation I referenced. The confusion resides here: https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531