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.
For many small business owners, Microsoft Excel is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare documents for distribution to partners or ...
How-To Geek on MSN
Stop manually hiding Excel rows and columns for meetings: Use this hidden tool instead
Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in ...
This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting. Excel offers numerous ways to ...
How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback