Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I keep my numbering system consecutive when I sort?
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
How can I keep my numbering system consecutive when I sort?
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 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I increment a numbering system in excel | Excel Discussion (Misc queries) | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
consecutive numbering | Excel Discussion (Misc queries) | |||
How do I set up an automated numbering system For my "Invoice Num | Excel Worksheet Functions | |||
How do I put automatic consecutive numbering on invoices? | Excel Discussion (Misc queries) |