Forum Discussion
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 sequence with the number above the manually entered RX number.
The table I'm showing here is what I would like to be able to create. We would need excel to auto-assign the RX numbers, EXCEPT when we manually enter an existing RX number. Any advice would be greatly appreciated.
This formula.
IF(A2="",220000+ROWS($220001:220001)-COUNTA($A$2:A2),"")
please open attached sample file with data and formula.
This formula.
IF(A2="",220000+ROWS($220001:220001)-COUNTA($A$2:A2),"")
please open attached sample file with data and formula.
- That worked perfectly! Thanks so much. I was trying to do it all in one column, which is probably why I couldn't get anything to work for me! I appreciate your help.
- You are welcome. Thanks for the feedback.
