How can I keep my numbering system consecutive when I sort?
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!
==============================================
"duchess_2" wrote in message
...
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?
|