Question Locked

sort in excel 2003

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am having 3 columns
Column A Column B Columm C
Formula Name of Person Date

Formula in Column A (=A1+1)

WHEN I SORT the column A gives me Value instead of Number that is there.

any help is highly appreciated.

Thanks

2 replies

by locolobo

I am assuming the following:

A2: =A1+1
A3: =A2+1
etc.

When I sorted the block by any column the formulas in column A are the same after as they were before. This makes sense sort of. This is similar to copying the cells. Excel appears to be automatically reindexing the formulas.

So I think I missed something. Could you explain a little more about what you are trying to do?

This discussion is closed to new replies.