Excel Forum

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.