Sorting

  • Thread starter Thread starter camaro46368
  • Start date Start date
C

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
 
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.
Click to expand...

Flip your monitor upside down. Then rotate the text 180 degrees.
 
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.
Click to expand...

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>
 
Back
Top