Reverse Order Of List

Zygomatic · Apr 2nd 2008

Simple one, probably: I want to mirror cells vertically, so if I have:

7
6
5
4
3
2
1

and want:

1
2
3
4
5
6
7

How would I do that? Thanks.

Dave Hawley · Apr 2nd 2008

Re: Mirror Cells Vertically

Sort, or create a Custom List

Zygomatic · Apr 2nd 2008

Re: Reverse Order Of List

Oh, duh. I'm an idiot.

Dave Hawley · Apr 2nd 2008

Re: Reverse Order Of List

Been there, done that

davecurtis · Apr 2nd 2008

Re: Reverse Order Of List

If you want a formula for it, assuming your list is in column A, starting in A1, then enter

=OFFSET($A$1,COUNTA(A:A)-ROW(),0)

in B1 and copy down.

Dave

Participate now!