ascending sorting

F

fofomama

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
 
E

excelent

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
 
G

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
 
Top