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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results