M
Mike
I need to set a spreadsheet up so that under sub-headings, there is a series
of numbers in the column.
It would be nice if these could auto-number as rows are added/deleted, as
regularly happens. I don't expect the auto-numbering to work ON rows
inserted but I'ld like the drag-fill to do it.
The layout is like this:
RfR1
i
ii
iii
iv
RfR2
i
ii
iii... and so on
I have managed to do part of it (including the Roman numerals - found out by
accident you could do that!!!) with this formula:
=LOWER(ROMAN(ROW(OFFSET(G10,-9,0)))).
However, I have to adjust the blocks where the numbering restarts (the -9 in
the example formula) manually, and I'm sure there must be a way of getting
round this. Because of this also, inserting or deleting a row throws the
second block out of synch (#REF! or wrong number after RfR2 in the example).
I've tried a number of variations on the formula without success - I never
did get my head properly round the OFFSET and/or INDIRECT functions! - and
my brain hurts!
Any suggestions would be much appreciated.
of numbers in the column.
It would be nice if these could auto-number as rows are added/deleted, as
regularly happens. I don't expect the auto-numbering to work ON rows
inserted but I'ld like the drag-fill to do it.
The layout is like this:
RfR1
i
ii
iii
iv
RfR2
i
ii
iii... and so on
I have managed to do part of it (including the Roman numerals - found out by
accident you could do that!!!) with this formula:
=LOWER(ROMAN(ROW(OFFSET(G10,-9,0)))).
However, I have to adjust the blocks where the numbering restarts (the -9 in
the example formula) manually, and I'm sure there must be a way of getting
round this. Because of this also, inserting or deleting a row throws the
second block out of synch (#REF! or wrong number after RfR2 in the example).
I've tried a number of variations on the formula without success - I never
did get my head properly round the OFFSET and/or INDIRECT functions! - and
my brain hurts!
Any suggestions would be much appreciated.