A question from my Columbus Indiana virtual seminar: How can we sort a data set by Absolute Value? They have columns with Forecast, Actual, and Variance. A large variance is bad, whether it is positive or negative. My solution today involves using a Dynamic Array and the SORTBY function. Also: using a helper column for people who don’t have dynamic arrays.

There is a UserVoice topic where you can vote to have Excel support this task: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/19453942-sort-by-absolute-value