MUO on MSN
Excel's dynamic array functions made me realize I'd been solving problems the hard way for years
Turns out half my old formulas were just dynamic arrays in disguise, written the long way.
Hosted on MSN
Level up your Excel game with smarter formulas
Excel has evolved far beyond VLOOKUP, with modern functions like XLOOKUP, FILTER, and dynamic array tools making data retrieval faster, cleaner, and more flexible. These functions let you search in ...
While certainly possible, this is not a practical method of recording such data. Suppose the program needed to record 100 scores? 100 variables would be required!
Some results have been hidden because they may be inaccessible to you
Show inaccessible results