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

You can also elect to have Excel remove any duplicate data from your spreadsheet. Use this function with caution – it's probably a good idea to back up your spreadsheet first.

Excel TREND Function is designed to fit a straight line (using the least squares method) to your data and extend that line into the future. This is particularly useful when you need to identify ...