how do you flip a column containing different text in each cell

column contains from top to bottom: A,B,C,D,E
and i want a column conatining after flip: E,D,C,B,A

Data - Sort -Descending?
"cybermix" wrote in message
...
column contains from top to bottom: A,B,C,D,E
and i want a column conatining after flip: E,D,C,B,A

Are the entries always in ascending alphabetical order as in the example? If
so, you can just select the column and Sort it in descending order. I doubt
if they are or you wouldn't have had to ask how to reverse them. If they
aren't, you can enter the following formula in column B1 and then copy it
down.

= OFFSET($A$1,MATCH("*",A:A,-1)-ROW(B1),0)

The MATCH("*",A:A,-1) expression returns the row number of the last
non-blank cell in column A. (Thanks to
http://www.mrexcel.com/forum/showthread.php?t=15062 for this trick.).

This assumes the values start in A1. You'll need to modify the formula if
they don't,

Well, if your column is sorted ascending alphabetically as in your example,
easiest thing to do would be to copy it to another copy and sort that column
in descending order.

But I suspect it's not that easy, so assuming your initial column is column
A and entries begin in row 1 and continue down the column unbroken (no empty
cells), then put this into row 1 of the other column:
=OFFSET($A$1,(COUNTA(A:A)-ROW()),0)
and fill it down to the end of the list in column A and see if that doesn't
do the trick.



"cybermix" wrote:

column contains from top to bottom: A,B,C,D,E
and i want a column conatining after flip: E,D,C,B,A

Try this...

Data in the range A1:A5

Enter this formula in B1 and copy down to B5:

=INDEX(A$1:A$5,ROWS(A1:A$5))

--
Biff
Microsoft Excel MVP


"cybermix" wrote in message
...
column contains from top to bottom: A,B,C,D,E
and i want a column conatining after flip: E,D,C,B,A