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.