Sorting

[camaro46368]

Thanks for reading
Have a column of numbers need inverted like this
all in column A
1
5
3
7
9
want to flip them like this
9
7
3
5
1
sounds easy? not for me.
Thanks
Bob

 

[dranon]

Thanks for reading
Have a column of numbers need inverted like this
all in column A
1
5
3
7
9
want to flip them like this
9
7
3
5
1
sounds easy? not for me.

Flip your monitor upside down. Then rotate the text 180 degrees.

 

[dranon]

Thanks for reading
Have a column of numbers need inverted like this
all in column A
1
5
3
7
9
want to flip them like this
9
7
3
5
1
sounds easy? not for me.

Put this in B1:

=OFFSET(A1,COUNT($A1:$A$1000)-ROW(),0)

copy b1 down as low as you need.

I still like the monitor idea better. <smile>