Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel | |||
Adding a KeyID column for sorting | New Users to Excel |