To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

You’re not alone. Despite its reputation as a workplace staple, Excel remains underutilized by many professionals who rely on basic functions while overlooking its true potential.

Then, ChatGPT became adept at writing basic Excel functions and formulas for us. Think of multipliers and sums, for example. ChatGPT itself came up with this instance: ...