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
|