How can I keep my numbering system consecutive when I sort?

[Guest]

I have created a spread sheet with a numbering system. I would like it to be
permanently consecutive when I do a sort...is there a way to create a
permanent row that is not affected when I sort the rest of the document?

 

[RagDyer]

One way:

Say your row #1 starts on Row5.
In A5 enter:
=ROWS($1:1)
And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Gord Dibben]

Duchess

In top cell in a column enter =ROW()

Drag/copy that down as far as you have data.

When you sort, that column of numbers will remain untouched because row 1 is
always row 1 and row 2 is always row 2 etc.

This assumes you are sorting top to bottom.

If left to right use =COLUMN() across the row.



Gord Dibben Excel MVP