This is the fomula I want to put in the cells A2:A10
IF(B2=Text,A1+1," ")
IF(B3=Text,A2+1," ")
The red "Text" is what I don't know how to enter for it to work in the formula.
I simply want to have the cells in column A have numbers beginning with 1 only if there is Text in the respective cells in Column B.
I'm using Excel version 1905
Thank you for any help.
Lew
IF(B2=Text,A1+1," ")
IF(B3=Text,A2+1," ")
The red "Text" is what I don't know how to enter for it to work in the formula.
I simply want to have the cells in column A have numbers beginning with 1 only if there is Text in the respective cells in Column B.
I'm using Excel version 1905
Thank you for any help.
Lew