On 10/2/08 7:47 PM, in article 59b5b49d.-1@[EMAIL PROTECTED]
"philimd@[EMAIL PROTECTED]
" <philimd@[EMAIL PROTECTED]
> wrote:
> 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.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
