News

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, ...
To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
With database functions, you can easily create a formula that incorporates all these criteria, allowing for nuanced data filtering and aggregation.