Rotate data table by 180 deg.

G

Gedi

Hi,
How to rotate data table (matrix) by 180 deg.?
Kind of what Transpose function do just I need to do two
Transposes in the same direction, as to rotate picture by
180 deg.
For example to rotate table:
1 2 3 4
11 12 13 14
21 22 23 24

And get:
24 23 22 21
14 13 12 11
4 3 2 1

Of course it is possible to do by linking one cell to
other, but very long process for big matrix.
Thank you.
Gedi.
 
J

Jason Morin

With your range called "myrng", select A1 of a new sheet,
enter this formula, and press <ctrl><shift><enter>:

=OFFSET(myrng,ROWS(myrng)-ROW(),COLUMNS(myrng)-COLUMN(),)

Now fill across and down.

HTH
Jason
Atlanta, GA
 
Top