|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have three lists of items (numbering about 150) on a single sheet using
columns A, D & G.
I need to sort these in alphabetical order continuous across all three
columns. All I get at the moment is each column individually sorted, which
is no good to me.
Can anyone help?
TIA
Ed
|
|
Give us an example with 3 rows of 3 columns before and after the sort.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Ed O'Brien" <edward.j.obrien[ at ]deletebtinternet.com> wrote in message
news:exodmwP0GHA.3464[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text] >I have three lists of items (numbering about 150) on a single sheet using
>columns A, D & G.
>
> I need to sort these in alphabetical order continuous across all three
> columns. All I get at the moment is each column individually sorted, which
> is no good to me.
>
> Can anyone help?
>
> TIA
>
> Ed
>
|
|
Try with new column which will have CONCATENATE function of A, D & G
columns and then sort table at new column.
Bruno Zikovic
|
|
Thanks for the response, Bernard. They're provisions....
Column 'A' runs from "Almonds" to "Trifles". Column 'D' at present runs from
"Baked Beans" to "Worcester Sauce" and 'F' starts with "Mustard - French"
and is yet to be sorted. After "T" (trifles) in column 'A' I want it to
continue with say 'U' at the top of the next column - 'D'.
Regards,
Ed
"Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote in message
news:O2EoY4P0GHA.5100[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > Give us an example with 3 rows of 3 columns before and after the sort.
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Ed O'Brien" <edward.j.obrien[ at ]deletebtinternet.com> wrote in message
> news:exodmwP0GHA.3464[ at ]TK2MSFTNGP03.phx.gbl...
>>I have three lists of items (numbering about 150) on a single sheet using
>>columns A, D & G.
>>
>> I need to sort these in alphabetical order continuous across all three
>> columns. All I get at the moment is each column individually sorted,
>> which is no good to me.
>>
>> Can anyone help?
>>
>> TIA
>>
>> Ed
>>
>
>
|
|
Thanks, Bruno.
I'm afraid I'm pretty poor with formulae. I tried a couple of things with
what you suggested, but got nowhere. Can you make a further suggestion to
simplify it so I can understand better? Think of me as just starting school,
even though I'm 70!!
Ed
<bzikovic[ at ]gmail.com> wrote in message
news:1157470261.101814.218960[ at ]p79g2000cwp.googlegroups.com...
[Quoted Text] > Try with new column which will have CONCATENATE function of A, D & G
> columns and then sort table at new column.
>
> Bruno Zikovic
>
|
|
I would start a datalist containing all the products in an out-of the -way
location of my sheet, say Column Z.
Then, in Columns A, D, and G, I would enter a *link* to Column Z.
A D G
=Z1 =Z51 =Z101
=Z2 =Z52 =Z102
=Z3 =Z53 =Z103
.... etc. ... etc. ... etc.
Then, just add your new products to Column Z and sort it, and your links
will display the 3 columns sorted among themselves.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ed O'Brien" <edward.j.obrien[ at ]deletebtinternet.com> wrote in message
news:eN5XISQ0GHA.2036[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text] > Thanks, Bruno.
>
> I'm afraid I'm pretty poor with formulae. I tried a couple of things with
> what you suggested, but got nowhere. Can you make a further suggestion to
> simplify it so I can understand better? Think of me as just starting
> school, even though I'm 70!!
>
> Ed
>
>
>
>
> <bzikovic[ at ]gmail.com> wrote in message
> news:1157470261.101814.218960[ at ]p79g2000cwp.googlegroups.com...
>> Try with new column which will have CONCATENATE function of A, D & G
>> columns and then sort table at new column.
>>
>> Bruno Zikovic
>>
>
>
|
|
That looks like it will work and I'll be setting it up to try it....
However, a friend has sent me a macro to control the data as I will be
adding and subtracting from time to time. It's called "snaking" and is
really cool!
Thanks and very best wishes,
Ed
"RagDyer" <RagDyer[ at ]cutoutmsn.com> wrote in message
news:edFCbbS0GHA.4932[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text] >I would start a datalist containing all the products in an out-of the -way
>location of my sheet, say Column Z.
>
> Then, in Columns A, D, and G, I would enter a *link* to Column Z.
>
> A D G
> =Z1 =Z51 =Z101
> =Z2 =Z52 =Z102
> =Z3 =Z53 =Z103
> ... etc. ... etc. ... etc.
>
> Then, just add your new products to Column Z and sort it, and your links
> will display the 3 columns sorted among themselves.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "Ed O'Brien" <edward.j.obrien[ at ]deletebtinternet.com> wrote in message
> news:eN5XISQ0GHA.2036[ at ]TK2MSFTNGP05.phx.gbl...
>> Thanks, Bruno.
>>
>> I'm afraid I'm pretty poor with formulae. I tried a couple of things with
>> what you suggested, but got nowhere. Can you make a further suggestion to
>> simplify it so I can understand better? Think of me as just starting
>> school, even though I'm 70!!
>>
>> Ed
>>
>>
>>
>>
>> <bzikovic[ at ]gmail.com> wrote in message
>> news:1157470261.101814.218960[ at ]p79g2000cwp.googlegroups.com...
>>> Try with new column which will have CONCATENATE function of A, D & G
>>> columns and then sort table at new column.
>>>
>>> Bruno Zikovic
>>>
>>
>>
>
|
|
|