Excel Forum

Mr Excel & excelisfun Trick 10: Turn Column / Row Upside Dow

See Mr Excel and excelisfun invert a range (Turn a range of cells upside down) with two different INDEX formulas. See the functions: INDEX ROW, ROWS, COLUMNS. See how to flip range 180 degrees (instead of TRANSPOSE function which only does 90 degrees.
See related videos:
Excel Magic Trick 307: Invert Range With Formula
Dueling: Invert a Range - 1015 - Learn Excel from MrExcel

Got a Question? Ask it Here in the Forum.