Number lines when it is filled

[G.Bregvadze]

Hi,

Recently I work on a project involving various formulas and functions in it.

At this moment I am trying to add some option to my file and I will explain briefly.

I intend to include formula which will number the cell in a line (row) when it is filled with some data.

I guess it is connected with array formula and also may be COUNTIF function but could not figure out how to use it.

I will upload a sample file which will show the idea.

Sample file: Number the lines.xlsx


Thank you in advances for help and support.

[hemesh]

Do you have only text, if so then use to generate the counting of numbers based on how many products are selected
below in b3
=IF(C3="","",COUNTA($C$3:C3))
and drag down

Or Below for Row Numbers
=IF(C3<>"",ROW(),"")

[[email protected]]

Hi,
Per your requirement you should use below formula.
=IF(C3<>"",ROW()-2,"")
Regards,
Suhas

[G.Bregvadze]

Thank you all, sorry for late response, I had some work to do, but now I tested the formulas and works great.

Thanks again for help.

[hemesh]

You are welcome and Thanks for the feedback !