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

To invert B1:B20
To B20:B1

Try this:

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

And copy down 20 rows.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eggle" wrote in message
...
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