reverse or invert column data

[Guest]

How can I reverse or invert a column of data?
I want to highlight a range and reverse the data
row 1 --> row N
row 2 --> row N-1
. . .


Trying Help and Search for "reverse" and "invert" gave no answers

 

[RagDyer]

To invert B1:B20
To B20:B1

Try this:

=INDEX($B$1:$B$20,20-(ROWS($1:1)-1))

And copy down 20 rows.