ROMAN is an effective way to add roman numbers as serial numbers in your Google Sheets Using with ROW Function.
It can return the row number of a reference and when you skip referring to any cell it will return the row number of cell in which you have entered it.
Here's the simple steps.
It has a benefit over other methods that it works even when you sort your data.
It can return the row number of a reference and when you skip referring to any cell it will return the row number of cell in which you have entered it.
Here's the simple steps.
- Enter the following formula in the cell from where you want to start. =ROMAN(ROW())
- Now drag the formula to down, up to the serial number you want.
It has a benefit over other methods that it works even when you sort your data.
COMMENTS