I'm making a script that will write a two-dimensional array to an Excel spreadsheet. The script is meant to be called from within other scripts. An outer loop runs once for every row in the array. An ...
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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback