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

-----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

.

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