Roman numeral sequence on every other line

[ollyhughes1982]

Hi.

I currently have a spreadhseet where I number rows with Roman Numerals in column A. However, I now want to add-in a spacer row between each of these and wondered if there is a way to make it continue the sequence - ignoring the spacer rows. The sequence will be starting at 'I' in cell A68, then 'II' in A70, 'III' in A72 etc., etc... The formula I currently use is: =ROMAN(ROW(1:1))

Thanks!

 

[Fluff]

How about

=IF(MOD(ROWS(A$68:A68),2)=1,ROMAN(ROWS(A$68:A68)/2+1),"")

 

[Toadstool]

Hi OllyHughes1982,

Try:

=IF(ISEVEN(ROW()),ROMAN((ROW()-ROW($A$68))/2+1),"")

 

[ollyhughes1982]

Thank you both, I will try both ways

 

[Fluff]

Another option is you know how many rows you want is

=LET(s,SEQUENCE(20),IF(ISODD(s),ROMAN(s/2+1),""))

just change the 20 to however many you want.

 

[ollyhughes1982]

Thanks. I have used Fluff's method - slightly adjusted to allow for two spaces, as I've now realised that I need two spacer rows in between each. So, I used =IF(MOD(ROWS(A$68:A68),3)=1,ROMAN(ROWS(A$68:A68)/3+1),"").

Thanks, both.

 

[Fluff]

Glad we could help & thanks for the feedback.