Hi Tony, it is something like that that I am looking for. But in my case it is a a bit more complicated.

In A1, I have the numbering. In B1, product name. Product has 1-5 features that are listed in rows C1-C5. So the next automated number can be in cells A2, A3, A4, A5 or A6, depending on how many features/rows the previous product has.

So the code would be something like this:

IF(There is text in B#,Insert number [1,2,3,4,...] in A#,blank cell)

I have trouble to make this formula working.