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

Excel's ascending and descending sort options are powerful tools, but they won't always sort values in a familiar and meaningful way. When this is the case, you might need a custom sort.

I'm working with a VERY large excel spreadsheet and I'm trying to apply a bunch of formulas to some sorted data. The way the data is sorted normally, I can't easily apply a formula that will work ...

Hi peopleNeed some help.I've got two columns A and B, A has five non-sorted numerical values (A1:A5) and I want to have those values automatically (i.e without going to Data->Sort etc) sorted in ...

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...