ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
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!
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!