How to add sequentials in a numbar using formula?-CodePudding

Home > Software engineering > How to add sequentials in a numbar using formula?

How to add sequentials in a numbar using formula?

Time：03-04

I need a Formula to use in my table, that will get me the following result

Please check this image

In B2 for example it is 1 2 3 4 5 In B3 As Another example it is 1 2 3 4 5 6 etc... thank you

CodePudding user response：

This is

CodePudding user response：

Try

Formula used in cell B2

=SUMPRODUCT(ROW(INDIRECT("1:"&$A2)))