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.
Here's a solution (not double-checked) using several Dynamic Array functions.
Thanks that is very helpful! The UNIQUE() function is also new to me, another experience of, Gee where were you 20 years ago when I needed an excel equivalent to SQL: COUNT(distinct [column_name])!
Kids these days won't know how easy they have it, lol.