•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
For some reason my COUNTA function is returning one too many results (also how to quickly fill many cells with sequential numbers?)
I have COUNTA to read from A2, to 502, since that goes up the the '500' that I need. However, for some reason, the function is returning 501. The first cell it's reading, a2, starts at 0 (labeled with the number zero), then up to cell 502, which is labeled 500.
Also, for desktop/free use, is there a faster way to do sequential numbering. I had a tough time doing the =sequence function, and then I don't have access to some of the other fill tools, and since I'm just learning, I don't have the money for a subscription right now.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#self-service analytics tools
#machine learning in spreadsheet applications
#Excel compatibility
#business intelligence tools
#row zero
#collaborative spreadsheet tools
#real-time data collaboration
#COUNTA
#Excel
#sequential numbers
#function
#sequence function
#desktop
#cell
#free use