Excel Forum
Similar Content
Sum a Range with Errors in Excel
Tutorial: How to sum a range of cells that contains errors. This requires an array formula, so it w...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Find the Next Blank Row with VBA Macros in Excel
Tutorial: Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This meth...

Excel Magic Trick 307: Invert Range With Formula

See how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values. See how to invert small to biggest, biggest to small, top to botton and side to side.

Got a Question? Ask it Here in the Forum.