I have 10000 rows and I need to number every 99th row. How can I do this.
Thank you,
Brian
Number every Nth row
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
I have 10000 rows and I need to number every 99th row. How can I do this.
Thank you,
Brian
Re: Number every 99th cell
Thank you, yet this is way above what I am familiar with. Is there a more simplified way.
Re: Number every Nth row
You didn't specify how the rows were to be numbered, so we assume row number.
Try this formula, copied down: =IF(MOD(ROW(),99)=0,ROW(),"")
Don’t have an account yet? Register yourself now and be a part of our community!