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.
Geeky Gadgets

How to use Excel INDEX & MATCH in formulas effectively

When you dive into the world of Excel, you quickly realize the power of its functions. Among these, the INDEX & MATCH formulas stand out as incredibly versatile tools for data lookup and retrieval.
How-To Geek on MSN

How to pick a random name from a list in Excel

Select winners in Excel using classic INDEX formulas or modern CHOOSEROWS and TAKE combinations.
TechRepublic

Use Excel tables for quick formula auto-fill

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...
EDN

Microsoft Excel: Tips & Tricks for Lookup Tables

Those of us over a certain age will remember using paper lookup tables for logarithms or trigonometry functions. Those who are younger will have been exposed to lookup tables in their programming ...
Geeky Gadgets

How to use Excel dynamic arrays in tables

What if you could unlock the full potential of Excel’s dynamic arrays within your tables, making your data management more efficient and powerful? Integrating dynamic arrays within Excel tables can be ...
JournalofAccountancy

Using Excel’s What-If Analysis with Data Table for data analysis

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...