# Excel Search and Sequential Numbering

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

Thread Starter
Hello,

I would like to create a formula that searches a cell in column B that contains "***patient subtotal," and then returns a number in column A if that formula is true. However, I would like there to sequential numbers in rows below where the formula is true.

For example
Column A Column B
1 ***patient subtotal
2 ***patient subtotal
3 ***patient subtotal

I used the formula below, but it doesn't work. May you please help me?

=IF((SEARCH("***patient subtotal",B22)),ROW())*1-countif(\$B\$22:B22,0))),"***patient subtotal","")

Thanks!

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

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 807,865 other people just like you!