How to Autonumber Rows If Adjacent cell NOT Blank in Excel

Autonumber Rows If Adjacent cell not Blank using IF and COUNTA functions in Excel

LIKE, SHARE AND SUBSCRIBE
THANK YOU!

Visit Us, Websites:

Join Us, Facebook Group:

[icezen]

how about sequence number when a certain text is entered?
example if i entered HEAD it will count to 1 and if i enter again HEAD it will count to 2 and so on but if i enter other than HEAD it will not count and leave it blank

[royaltyonline-coza]

How did you get this right? The formular fails on my side. 😞

[alterchannel]

doesn't work if blanks have formulas in cell

[jacdru]

This does not work as it counts "", as a non blank . Any ideas?

[woodox]

It show false, and start in number 2 if put word on first cell

[kaushikvishwas]

WHAT IS YOUR SYESTOM NAME OR MODAL NUMBER ? BECOUSE THIS IS SHOWING UP (YOU'VE ENTERED TOO FEW ARGUMENTS FOR THIS FUNCTION).

[ashikinrahmad]

=IF(B2<>"", COUNTA($B2:B$2), "")