•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?
Our take
In Excel, ensuring that equivalent cells match is crucial for accurate data management, especially in larger tables. If you're working with a table where specific cells, like those for Mary and Alex, should have the same values, implementing a checksum can help you easily identify discrepancies. This solution should be scalable, allowing for seamless integration as you add more rows and columns. By using formulas that dynamically check for equality, you can maintain data integrity without resorting to cumbersome IF statements.
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]
Read on the original site
Open the publisher's page for the full experience