•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
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#AI formula generation techniques
#formula generator
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#row zero
#rows.com
#AI-native spreadsheets
#Excel compatibility
#google sheets