# Solved: Sequential Number if Cell Contains Text

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### deastew

I would like to assign a sequential number in Column A if a cell in Column B contains text.

I used the following formula but it did not work:

=IF(ISTEXT(B26),"",COUNTA(B26:B26))

In essence, I want the following:
Row Column A Column B
1 1 True
6 2 True
8 3 True

Can anyone help?

Thanks!

#### etaf

Wayne
Moderator
there maybe a better way to do this

Assume the data starts in A2 and B2

in A2 put
=IF(OR(ISTEXT(B2),B2=""),MAX(\$A\$1:A1)+1,"")
and copy down

see attached

#### Attachments

• 11.1 KB Views: 34

#### deastew

Thank you. That worked!!!

#### etaf

Wayne
Moderator
your welcome thanks for letting us know

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On