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.
Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...
How-To Geek on MSN
How to use the MAP function in Microsoft Excel
Use MAP and LAMBDA to build centralized, error-proof, and auto-spilling Excel spreadsheet systems.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback