: Saturday, April 14, 2012 3:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Sorting cells
Hi Rajan,
I did ... and it doesn't work. If you sort B1:B4 using A-Z, the cells in
column B remain the same ie B1 holds =A1, B2 holds =A2 etc. I want to see
Bonn in B1 (actuall
8:51:53 PM UTC+1, Rajan_Verma wrote:
>
> Hi
>
> Why don’t you use sort by the way
>
>
>
> Rajan.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *kenrock
> *Sent:* Apr/Thu/2012 08:59
> *To:* excel-m
Hi
Why don't you use sort by the way
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of kenrock
Sent: Apr/Thu/2012 08:59
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sorting cells
I have the word "London" in
I have the word "London" in cell A1, "Paris" in A2, "Bonn" in A3 and
"Madrid" in A4. I put the formula =A1 in cell B1, =A2 in B2, in B3 =A3 and
in B4, I put =A4. I will then see a copy of column A in column B
I want to sort B1:B4 alphabetically so that B1 will hold =A3, that is, the
first wo
