Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbering of Grouped Rows
Hi,
I have a number of sets of "grouped" rows. I want to number the sets sequentially but the auto-fill down doesn't work, because it will fill all of the grouped cells as well. Additionally, the grouped rows are NOT the same size. Ex. I want the number "1" and the number "2" to appear in column A, rows 1 and 5 respectively. Row# Column A 1 1 2-4 Grouped 5 2 5-10 Grouped Any help is appreciated. Thanks in advance, --Phil |
#2
|
|||
|
|||
-----Original Message----- Hi, I have a number of sets of "grouped" rows. I want to number the sets sequentially but the auto-fill down doesn't work, because it will fill all of the grouped cells as well. Additionally, the grouped rows are NOT the same size. Ex. I want the number "1" and the number "2" to appear in column A, rows 1 and 5 respectively. Row# Column A 1 1 2-4 Grouped 5 2 5-10 Grouped Any help is appreciated. Thanks in advance, --Phil . |
#3
|
|||
|
|||
If you hide the rows that are grouped,
you can prime the pump by puttin 1 in A1. Select A2:A???? Then hide all the groups. Then edit|goto|special|visible cells only Then use a formula like: Put this is the first visible cell (say A5) =max($A$1:A5)+1 but hit ctrl-enter to populate all the visible cells. Phil wrote: Hi, I have a number of sets of "grouped" rows. I want to number the sets sequentially but the auto-fill down doesn't work, because it will fill all of the grouped cells as well. Additionally, the grouped rows are NOT the same size. Ex. I want the number "1" and the number "2" to appear in column A, rows 1 and 5 respectively. Row# Column A 1 1 2-4 Grouped 5 2 5-10 Grouped Any help is appreciated. Thanks in advance, --Phil -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet protection with grouped rows? | Excel Worksheet Functions | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
How do i change the numbering shceme of my rows? | Excel Worksheet Functions |