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
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
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
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
On Sun, 13 Aug 2006 00:14:02 -0700, fofomama
<[email protected]> wrote:
> 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
Thanks
This is what I have done but it didnt work.
"excelent" wrote:
> 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
>
thanks
This is what I have done but still it is not working
"excelent" wrote:
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks