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.
Sorry, it is taking me longer to get a sample together than I thought. Got pulled away by other stuff. I do appreciate the link to the dynamic array functions. What I am learning now is stuff that I was doing manually in 2007 via a series of nested IF/INDEX/MATCH fns.
Stick with it. Modern, dynamic array, versions are an order of magnitude improvement on the old spreadsheet junk one knew and loved! I used CSE all the time, but it was painful.
A function that could be useful as a way of creating a range of conditional sums would be one of GROUPBY and PIVOTBY.