sort in excel 2003

By nishkrish ·
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

It's not working for me

by LocoLobo In reply to sort in excel 2003

I am assuming the following:

A2: =A1+1
A3: =A2+1

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?

Related Discussions

Related Forums