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.
When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.
How-To Geek on MSN
Creating drop-downs from table headers in Excel seems impossible—but this trick fixes it
Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.
Excel formulas are the foundation of effective data management and analysis. Selecting the right formula can significantly enhance your productivity, minimize errors, and improve the accuracy of your ...
For you advanced users who want to skip ahead: You apply the conditional formatting using a custom formula and some variation on the INDIRECT function. In addition to specifying the column and row, ...
Duplicates in the same column are easy to find by sorting or filtering. Duplicates that span multiple columns require a bit of setup, but the solution's not difficult to implement. Finding duplicate ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results