•1 min read•from 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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com