I want to auto increment column A if column B is not empty. For example if I type anything to B14, I want A14 to auto increment.
How can I do this?
if B column is not interrupted by an empty cell you are good with just:
=SEQUENCE(COUNTA(B2:B))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With