Sort Cells/Columns

[Ed O'Brien]

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

 

[Bernard Liengme]

Give us an example with 3 rows of 3 columns before and after the sort.
best wishes

 

[bzikovic]

Try with new column which will have CONCATENATE function of A, D & G
columns and then sort table at new column.

Bruno Zikovic

 

[Ed O'Brien]

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

 

[Ed O'Brien]

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

 

[RagDyer]

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.

 

[Ed O'Brien]

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