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 Geek on MSN
How to simplify complex Excel formulas for better auditing
Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.
Sometimes, you may want to convert data in one column to organized data in Excel. This is especially true when you copy-paste unorganized data from a word editor to an Excel sheet. All the data is ...
How to use Excel formulas to compare multi-column lists Your email has been sent Duplicates in the same column are easy to find by sorting, filtering, and using conditional formatting. When none of ...
See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback