reverse data range

[lensturn]

Hi,,,,could someone help here please,, I have this range of columns of data and I want to reverse the order vertically.

5 3 9 8
9 2 1 7
6 8 7 8
3 7 9 2
This is just a shortened down example, what I want is to change it to this.

3 7 9 2
6 8 7 8
9 2 1 7
5 3 9 8

I would be grateful for any help .
Len

[Pete_UK]

Might be better on another sheet if you have a lot of data, so assuming your data is on Sheet1 starting in cell A1, put this formula in cell A1 of Sheet2:

=INDEX(Sheet1!A:A,COUNT(Sheet1!$A:$A)-ROWS($1:1)+1)

Then you can copy this across and down for as many columns and rows that you have in Sheet1.

Hope this helps.

Pete

[lensturn]

Works a treat, thank you
len

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.