What is a Dynamic Array Formula in Excel?

[@josealvesferreira1683]

thanks, very good

[@MrSrinilal]

Nice, Thank you very much

[@ExcelU]

No problem!

[@PaulEBrownbill]

excellent explanation, thanks Paul

[@ExcelU]

Glad it was helpful and thank you!

[@bluetaco-b1i]

Is it possible to automate my workflow as a tax associate, using Excel. I work on partnerships, and was wondering what skill do you think would be the most useful, or which ones you think I should focus on first, i.e. PowerQuery, PowerPivot or Functions?

[@thereelaccountant9246]

Power Query for sure. Especially for automation