Invert a column of data

[Debby]

How do you invert a column of data? Given column A, how can you easily invert
A to get column B?
A B

1 5
2 4
3 3
4 2
5 1

Cell referencing always works in a positive fasion. How do you get it to
work in a negative fasion? For the first cell in column B I want to write
"=A5" and copy it downward negatively getting:
B
"=A5"
"=A4"
"=A3"
"=A2"
"=A1"

What is the fastest way to do this?
Thanks,

 

[Bob Greenblatt]

How do you invert a column of data? Given column A, how can you easily invert
A to get column B?
A B

1 5
2 4
3 3
4 2
5 1

Cell referencing always works in a positive fasion. How do you get it to
work in a negative fasion? For the first cell in column B I want to write
"=A5" and copy it downward negatively getting:
B
"=A5"
"=A4"
"=A3"
"=A2"
"=A1"

What is the fastest way to do this?
Thanks,

Copy the range in column A to column B. then select the range in column B
and Sort it descending.

 

[Debby]

Thanks Bob. I need to add one more complication that was not apparant in my
first example. The values are not sequential. Take this new example: Given A,
how to invert to get B?

A B
-6 8
-12 11
-16 17
17 -16
11 -12
8 -6

Using the sort/descend would sort the values from smallest to largest. I'm
not looking to sort them, just flip them so the last value is now the first
value and so forth.
Thanks,
Debby

 

[Debby]

I got it now, I found another post you replied to in August.
I need to use an identifier column and sort descending using that column.
Thanks for your help.