reverse or invert column data

E

Eggle

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
 
R

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