| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flipping a worksheets contents?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Flipping a worksheets contents?
flip your monitor over.
"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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Flipping a worksheets contents?
Hi Niceguy,
Select your data A1:A5 Go to DataSort Click on Options Button Check Sort left to right Click OK Check descending Click OK HTH Martin "niceguy" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Flipping a worksheets contents?
That was the first thing I tried! But I had a hard time reading the screen,
so I thought there had to be a better way! =) "Mike" wrote: flip your monitor over. "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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Flipping a worksheets contents?
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Flipping text | Excel Worksheet Functions | |||
| Flipping a Spreadsheet | Excel Worksheet Functions | |||
| flipping a spreadsheet | Excel Worksheet Functions | |||
| Data Flipping | Excel Discussion (Misc queries) | |||
| Flipping the order around? | Excel Discussion (Misc queries) | |||
Linear Mode
