Assign a sequential number IF a cell contains text

I want to automatically number cells IF the cell next to it contains text.

If you look at the image, column V contains some blank cells, some with text. Column U numbers those cells with text sequentially. However, I did this manually and I want it to be automatic.

What formula (or, more likely, combination of formulas) would I use to return the number?

If needed, I can enter information into the blank cells, e.g. "FALSE" or "0".

Thanks so much!

Capture.JPG

Hi
=IF(ISTEXT(v1),COUNTA($v$1:v1),"")
then drag down

You've solved all my problems! Thank you so much!

One edit: Because my cells were in row 5, the formula had to be modified to the following.
=IF(ISTEXT(V5),COUNTA($V$5:V5),"")

Question for you: how does that work? In particular, I don't understand the "counta($v$5:v5) portion.

Again, thank you!

Counta formula counts cells that are not empty. when you put $ sign makes cell absolute. So first cell stays abslute and others relative and when you drag down the range will enlarge automatically.
Istext returns true or false if the cell is text.
as a result. if the particular cell is text then calculate non empty cell otherwise nothing which is "" sign.

Okay, I didn't know about the absolute vs. relative part. Thank you!

Originally Posted by e.isayev

Hi
=IF(ISTEXT(v1),COUNTA($v$1:v1),"")
then drag down

Thanks Isayev. I registered to this forum just because of you

Regards
Nedim

I noticed it I will try to be active user for this forum. Regards.