thks Biff!
this is what I exactly wanted!!

-via135


Hi!

Suppose your data is in the range A1:E3 and looks like this:

1;2;3;4;5
2;3;4;5;6
3;4;5;6;7

And you want:

3;4;5;6;7
2;3;4;5;6
1;2;3;4;5

=INDEX($A$1:$E$3,3+1-ROWS($1:1),COLUMNS($A:A))

Copy across then down.

Biff


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=539557