How-To Geek on MSN
Excel's UNIQUE function can't skip columns—unless you use this trick
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
How to sort a single column in Excel without disrupting the rest of the spreadsheet Your email has been sent We tend to view spreadsheet data as a whole, and that’s as it should be. Seldom does a ...
Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other direction. However, data may not be in alphabetical or ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback