Sorting alphabetic

[goki]

Hi,

The problem is sorting alphabetic.

Thanks...

[Richard Buttrey]

Hi,

What exactly is the problem that a standard SORT won't achieve?

Rgds

[goki]

Yes, table problem

[martindwilson]

if you want to populate your table see attached then sort columns a:c by header row "list"

[bstoyano]

hi,
here is a possible solution:
Sort the data using 2 level sorting: level 1 for the Yes/No column, and level 2 for the ABC column. Thus you will have all the YES's and then all the NO's.

[Richard Buttrey]

Hi,

I still don't understand. You say you have a sorting problem but your example seems to suggest you want to produce the 5 column table in I:M. Is this in fact what you're trying to achieve?

If so you'll need to both filter and sort the data.

But if not why not just sort A2:B12 using B as the first sort key and A as the second.

Regards

[goki]

if you want to populate your table see attached then sort columns a:c by header row "list"

Hi,

Column D and G good (Yes/No)

Column E and H no good sorting.(First A-AA) or (AA-A)

[martindwilson]

sorry not sure what you mean. when a:b:c sorted by col a header list it gives

Please Login or Register  to view this content.

in c and e
and

Please Login or Register  to view this content.

in g and h

[goki]

if you want to populate your table see attached then sort columns a:c by header row "list"

New file.....

[martindwilson]

works for me you are not sorting your list!!!
or is there some reason you cant sort it?

[goki]

Mr Martin thanks four your help.

No good.

[martindwilson]

you havent sorted your list!!!! you must sort the list in cols a to c for it to work

[goki]

Mr.Martin ok

thanks.