Forum Discussion

Amy Lucas's avatar
Amy Lucas
Copper Contributor
Apr 24, 2018
Solved

IF formula, I think???

I am trying to create a formula that allows the table above.  I have used IF commands and reviewed many tutorials, but I can not get the number after the manually entered RX number to stay in s...
Formulas & Functions
Need Help
  • Jamil's avatar
    Jamil
    Apr 24, 2018

    This formula.

     

    IF(A2="",220000+ROWS($220001:220001)-COUNTA($A$2:A2),"")

     

    please open attached sample file with data and formula.

Jamil's avatar
Jamil
Bronze Contributor
Apr 24, 2018

This formula.

 

IF(A2="",220000+ROWS($220001:220001)-COUNTA($A$2:A2),"")

 

please open attached sample file with data and formula.

Resources