sorting cells with formulas

[philimd]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a column with numerical results based formulas. (grades on school work). In the next row, I manually enter a grade (A, B, C, D etc); When I try to sort by the formula results, that row does not change. The row next to it (the A, B, C, etc) changes, just as though the formula column has been sorted, but as above, the numbers do not change. I tried the same sheet on multiple versions of excel (2004 and 8 for Mac, and also a windows version), but still, no luck. I thought that perhaps the file itself was corrupt, so I did it from scratch, but still no luck. I have formatted the formula results as a number or text, but still doesn't work. Any ideas???

Thanks

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a column with numerical results based formulas. (grades on school
work). In the next row, I manually enter a grade (A, B, C, D etc); When I try
to sort by the formula results, that row does not change. The row next to it
(the A, B, C, etc) changes, just as though the formula column has been sorted,
but as above, the numbers do not change. I tried the same sheet on multiple
versions of excel (2004 and 8 for Mac, and also a windows version), but still,
no luck. I thought that perhaps the file itself was corrupt, so I did it from
scratch, but still no luck. I have formatted the formula results as a number
or text, but still doesn't work. Any ideas???

Thanks

Can you describe in a little more detail what you worksheet looks like. What
is the formula, and what you are expecting for the result after the sort.
The problem is probably that you are using relative addresses rather than
absolute address in your formula, but I don't want to suggest a solution
without understand your data.