•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Don’t want formulae to auto update cell once data moves
Using formula =COUNTA($C$5:$C$6000) and have to add rows of data to the top a few times a day. Everytime I add data, $C$5 gets updated to the new location. I want it to always start at C5
The first 4 rows are not merged, but frozen.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#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
#Excel compatibility
#formula generator
#Excel alternatives
#COUNTA
#$C$5
#data
#formula