| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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? |
| 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) | |||
Threaded Mode
