How to reverse column values in excel?
 

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

How to reverse column values in excel?
 

Try the below formula and copy down as required

=INDEX($A$1:$A$7,ROWS($A$1:$A$7)-ROW(A1)+1)

--
Jacob (MVP - Excel)


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

How to reverse column values in excel?
 

Hi,

Lets assume this data are in a1 down.

In B1 enter a 1 and in B2 enter a 2.

Select B1 & B2 and fill down as far as there are data in column A.

Select both columns and sort on column B 'descending'

Delete column B
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


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

How to reverse column values in excel?
 

Data in the range A1:A7.

Enter this formula in B1 and copy down to B7:

=INDEX(A$1:A$7,ROWS(A1:A$7))

If you want to, after you get the data reversed you can convert the formulas
to constants then get rid of the original data.

--
Biff
Microsoft Excel MVP


"Denish D" wrote in message
...
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...

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