Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reverse the entries in an Excel column
Would like to quickly reverse the entries in a row or column (make the first
entry last etc until the last entry is first), perhaps with a Macro or some trick. I could number the columns and then do a reverse sort, but was wondering if there is a quicker way. I am using Microsoft Office Excel 2003 SP2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reverse the entries in an Excel column
Source data in A1:A10
In B1: =INDEX(A:A,COUNTA(A:A)-ROW(A1)+1) Copy B1 down to B10 to reverse what's in A1:A10 Source data in A1:Z1 In A2: =INDEX(1:1,COUNTA(1:1)-COLUMN(A1)+1) Copy A2 across to Z2 to reverse what's in A1:Z1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "PapaJo4" wrote: Would like to quickly reverse the entries in a row or column (make the first entry last etc until the last entry is first), perhaps with a Macro or some trick. I could number the columns and then do a reverse sort, but was wondering if there is a quicker way. I am using Microsoft Office Excel 2003 SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
eliminating matched records! | Excel Worksheet Functions | |||
How do I set up an Excel column to not allow duplicate entries (m. | Excel Discussion (Misc queries) | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
set up a column in excel with unique entries | Excel Discussion (Misc queries) |