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 (actually =A3), London in B2 (actually =A1), Madrid in B3 and
Paris in B4.
Regards, kenrock
On Friday, April 13, 2012
Hi Haseeb,
Thank you for your prompt reply.
There appears to be a lot to get my head around here so I will now try to
understand it!
Many thanks!
On Thursday, 12 April 2012 18:09:52 UTC+1, Haseeb A wrote:
>
> Hello Kenrock,
>
> Assume you will have header in row 1 & data starts o
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
