C
cybermix
column contains from top to bottom: A,B,C,D,E
and i want a column conatining after flip: E,D,C,B,A
and i want a column conatining after flip: E,D,C,B,A
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Luke M
Data - Sort -Descending?
S
SVanDee
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,
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,
J
JLatham
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.
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.
T
T. Valko
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))
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))