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 use the MAP function in Microsoft Excel
Use MAP and LAMBDA to build centralized, error-proof, and auto-spilling Excel spreadsheet systems.
An icon in the shape of a lightning bolt. Impact Link Excel is a great program with hundreds of helpful functions. Unfortunately, one function it's lacking is a simple way to merge two or more columns ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback