Prev: conditional formatting
Next: Email Macro
From: Denish D on 14 May 2010 05:46
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...

From: Jacob Skaria on 14 May 2010 05:51
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...
>
From: Mike H on 14 May 2010 05:52
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...
>
From: T. Valko on 14 May 2010 10:06
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" <DenishD(a)discussions.microsoft.com> wrote in message
news:4E962B01-02D6-40DD-B98E-B08FB43E4EC7(a)microsoft.com...
>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...
>


From: Bernd P on 14 May 2010 17:35
On 14 Mai, 10:46, Denish D <Deni...(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: conditional formatting
Next: Email Macro