| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reverse column values in excel?
On 14 Mai, 10:46, Denish D wrote:
I have values in a column like: 546 3242 54 5645 257 245 1565 i Want to make them in reverse order as : 1565 245 257 5645 54 3242 546 Can any one help me... If D is the name of the range you want to reverse (or just replace by your range in the following formula, for example by A1:A7), then select the destination range where you want your result and array- enter: =INDEX(D,ROWS(D)-ROW(INDIRECT("1:"&ROWS(D)))+1) Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XY Scatter Chart in Excel 2007 - Cant Reverse Values | Excel Discussion (Misc queries) | |||
| Reverse the signs of values | Excel Worksheet Functions | |||
| reverse the entries in an Excel column | Excel Discussion (Misc queries) | |||
| How do I reverse the order (sequence) of a column of data in Excel | Excel Worksheet Functions | |||
| Reverse values but not X axis | Charts and Charting in Excel | |||
Threaded Mode
