ascending sorting

[Guest]

dont know.i want to sort a column which is the result of two added columns
but it is not working ,I dont know why

 

[Guest]

I thinkits becourse of the formulas

1 way:
select all cells in column with data
click on copy icon
click on arrow in paste icon
select values
all ur formula is gone only values stays - now sort

another way:
select all cells in column with data
click on copy icon
select a emty column
click on arrow in paste icon
select values
now sort new column

 

[Gord Dibben]

Copy a small selection of your data and paste it into a follow-up posting with
some description of what you want it to look like after sorting.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks
This is what I have done but it didnt work.

 

[Guest]

thanks
This is what I have done but still it is not working