In a helper column

=INDEX($A$1:$A$5,5-(ROW(A1)-1))

Copy down


Gord Dibben MS Excel MVP


On Sat, 28 Jun 2008 07:23:00 -0700, niceguy
wrote:

So if I have a Worksheet with the Cloumn like this... A1, A2, A3, A4, A5
and I want to flip it to show in this order... A5, A4, A3, A2, A1
How would I do that? Thanks!