Nuacht

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...
A Function Arguments dialog box will appear. The process is explained in method one for the Function Arguments dialog box. Read: How to use the Find and FindB functions in Excel.
Learn how to parse data in Microsoft Excel easily using our step-by-step guide.
If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.