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

Follow sports column writer Scott Fowler in Charlotte NC for his take on college and professional football, basketball and other sporting events.