sort without the sort button

[simonmarsh]

Hi all.

I have a table of strings that I have concatenated from several dro
down lists. I now need to sort this data into a single column
alphabetically and list all unique entries along with a percentage.

I think I can do the listing unique entries etc. if I can just sort ou
the problem I am having with sorting a column alphabetically.

The problem is that I want to be able to use cell formulas to do th
sorting as I want the sheet 'idiot proof'. The only user intervention
want is for them to initially select the data they use from the dro
down lists.

I can do this using macro's I know but I also want to avoid them.

Are there any formulas I can use to sort data?

Thanks

Simon

 

[CLR]

I think not.......but you can record a macro and assign it to a pushbutton
or drawing object and it's pretty idiot-proof for the end-user.......all
they do is push the button and all the sorting is done the way you want it
by macro......

Vaya con Dios,
Chuck, CABGx3

Hi all.

I have a table of strings that I have concatenated from several drop
down lists. I now need to sort this data into a single column,
alphabetically and list all unique entries along with a percentage.

I think I can do the listing unique entries etc. if I can just sort out
the problem I am having with sorting a column alphabetically.

The problem is that I want to be able to use cell formulas to do the
sorting as I want the sheet 'idiot proof'. The only user intervention I
want is for them to initially select the data they use from the drop
down lists.

I can do this using macro's I know but I also want to avoid them.

Are there any formulas I can use to sort data?

Thanks

Simon M


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements