how do you invert a column

[Chris]

0
1
2
3
4
5

I would like

5
4
3
2
1
0

[Dav]

highlight the values
then click on the ZA button or choose data, sort, descending

Regards

Dav

[Muhammed Rafeek M]

sort Descending order
Data->Sort

"Chris" wrote:

> 0
> 1
> 2
> 3
> 4
> 5
>
> I would like
>
> 5
> 4
> 3
> 2
> 1
> 0
>

[Toppers]

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
>

[Ken Johnson]

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

[Chris]

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
> >

[Toppers]

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
> > >

[RagDyer]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>> >