Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
0
1 2 3 4 5 I would like 5 4 3 2 1 0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
sort Descending order
Data-Sort "Chris" wrote: 0 1 2 3 4 5 I would like 5 4 3 2 1 0 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
highlight the values then click on the ZA button or choose data, sort, descending Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=573749 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
Assuming data in column starting row 2, and with no embedded blanks, then in
B2 put: =INDIRECT("A" & COUNTA(A:A)+2-ROW()) HTH "Chris" wrote: 0 1 2 3 4 5 I would like 5 4 3 2 1 0 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
Chris wrote: 0 1 2 3 4 5 I would like 5 4 3 2 1 0 Hi, If they are continuously increasing as you have shown then just sort descending. If they are not as shown, eg... 4 3 5 2 0 1 and you need ... 1 0 2 5 3 4 then one way is to insert a new column next to it. In the new column enter a continuously increasing series of numbers. Select both columns (and any other columns that need to stay with your column) then sort the new column descending, then delete the inserted column. eg... 4 1 3 2 5 3 2 4 0 5 1 6 after sort descending becomes... 1 6 0 5 2 4 5 3 3 2 4 1 Ken Johnson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
Ah thank you, just what I was looking for. Except in your formula it should
be +1 not +2. It's amazing the various ways you can write a formula in Excel. I think I asked this question about a month ago and someone told me how to write the formula using the index function. Thanks again. "Toppers" wrote: Assuming data in column starting row 2, and with no embedded blanks, then in B2 put: =INDIRECT("A" & COUNTA(A:A)+2-ROW()) HTH "Chris" wrote: 0 1 2 3 4 5 I would like 5 4 3 2 1 0 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
1 if data starts in row 1. Anyway, it's working so thanks for the feedback.
"Chris" wrote: Ah thank you, just what I was looking for. Except in your formula it should be +1 not +2. It's amazing the various ways you can write a formula in Excel. I think I asked this question about a month ago and someone told me how to write the formula using the index function. Thanks again. "Toppers" wrote: Assuming data in column starting row 2, and with no embedded blanks, then in B2 put: =INDIRECT("A" & COUNTA(A:A)+2-ROW()) HTH "Chris" wrote: 0 1 2 3 4 5 I would like 5 4 3 2 1 0 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you invert a column
Don't know if this is the one you're talking about, but here's a reversing
formula using Index: =INDEX($A$1:$A$20,20-(ROW(A1)-1)) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Chris" wrote in message ... Ah thank you, just what I was looking for. Except in your formula it should be +1 not +2. It's amazing the various ways you can write a formula in Excel. I think I asked this question about a month ago and someone told me how to write the formula using the index function. Thanks again. "Toppers" wrote: Assuming data in column starting row 2, and with no embedded blanks, then in B2 put: =INDIRECT("A" & COUNTA(A:A)+2-ROW()) HTH "Chris" wrote: 0 1 2 3 4 5 I would like 5 4 3 2 1 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock data manipulation | Excel Worksheet Functions | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |