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?
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?
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
On Mon, 24 Oct 2005 12:46:03 -0700, duchess_2
<[email protected]> wrote:
>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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks