•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formulas that depend on sorted data, how to 'lock' them?
I have sequential data. I sort by date and have some formulas to identify anomalies, which only work when the rows are sorted by date.
Simplified example, when column A is a date, ascending. if((B2 - B1) < 0, True, False).
After calculating, I always copy and paste as text to ensure the values will not change. I do this in PQ or manually. I am paranoid about the values changing - I have to be 100% certain they do not change, no matter what - even if a row used in the formula is deleted (by mistake, but still...).
This is unelegant. Surely there is a better way, right?
[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
#row zero
#formula generator
#Excel alternatives
#sorted data
#formulas
#anomalies