Sorting

[brianwakin]

Is there any way to sort cells by value when the value is determined by a
formula? I am trying to sort in ascending order and the results aren't even
close to correct. Any help would be greatly appreciated.
--
Brian

[Gary''s Student]

The reason you are having problems with the sort is that the sort moves cells
around and after moving the formula in the cells may no longer refer to the
correct items. For example, if a cell refers to other cells in the same row,
moving that cell may produce incorrect results unless the entire row is moved
with the sort.

If you want to sort only a column of data, it is always safe to first copy
the column and paste it as value "elsewhere". Then sort the new column which
contain only values and no formulae.

Good Luck
--
Gary''s Student


"brianwakin" wrote:

> Is there any way to sort cells by value when the value is determined by a
> formula? I am trying to sort in ascending order and the results aren't even
> close to correct. Any help would be greatly appreciated.
> --
> Brian