•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Checksum for equivalent cells in a table?
I have an Excel table that looks like this. In this, equivalent cells should always equal each other - ie both Mary/Alex cells equal 8, which is correct.
What I want is some sort of checksum which can highlight when two cells that are supposed to be equal aren't, such as looking like this (not picky about appearance here). Importantly, I also need for it to be easily expandable for additional rows and columns - the actual table has over 100 rows, with more being added routinely. If it was smaller I could just brute force it with a bunch of =IF statements, but that's not feasible for this.
Desktop Excel 365, intermediate knowledge
Thanks.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#Excel
#checksum
#equivalent cells
#table
#intermediate knowledge
#rows and columns
#highlight
#=IF statements
#brute force
#desktop Excel 365
#data validation
#cell comparison
#dynamic range