1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

What formula for sequencing number but when adjacent row is blank it wont get sequenced

I have tried this formula form chat gpt: =IF(B14="","",COUNTIF($B$14:B14,"<>")) =IF(B14="","",SUBTOTAL(103,$B$14:B14)) =IF(B14="","",SUBTOTAL(103,B$14:B14))

But the blank row still get counted like: B1 has data, number 1 B2 has no data, blank B3 has data, number 3

What i want is: B1 has data, so its number 1 B2 has no data, so its blank B3 has data, so its number 2

Iam using google spreadsheets, sorry if it confusing iam still new here

*edit: thanks for the help everyone i think the previous formula not doing what i wanted is because the cell that i thought blank is filled with vlookup formula, iam using =IF(B14 = "", "", MAX(A$13:A13) + 1) and it work!

submitted by /u/Barusan_buat
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com