To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Collaborate on Spreadsheets How to share Excel files with others on your network.

I'm experiencing this problem lately on 2007, but I've seen it on other versions. Periodically, Excel will claim it's unable to save a file on a networked drive because the file is "in use". This ...