How-To Geek on MSN
Excel finally fixed its worst problems—but you're still using the old workarounds
Excel has quietly gained dynamic arrays, XLOOKUP, Power Query, and Python, yet many still work the old way.
This article covers a developing – and complicated – area, and doesn't constitute legal advice. Please let us know if you've feedback or questions we've not answered below by emailing ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results