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.