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.
Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute reference ...
Microsoft Excel spreadsheets frequently use similar formulas along columns. For example, you might need to keep a running total or tabulate a list of product inventories. Repetitively typing each ...
How-To Geek on MSN
How to use the MAP function in Microsoft Excel
Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...
Reference: The cell or range of cells or range of cells for which you want to return the column number. It is optional. You will notice that the cell will return the cell number of the cell that ...
Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback