wow Paula I am really excited about Dynamic Arrays in Excel. They are totally awesome. Dynamic Arrays look like a real game changer. What I really love is that dynamic arrays work with most existing formulas that requires a range. What I do not like is they are not backward compatible. Do you know if you use a Dynamic array on a sheet to lets say replace thousands of rows of vlookup, will the file be smaller?

how do I see myself apply them. Interesting question. Everywhere I think. i will have to wait till I have the feature to see where it works best.