•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 a table where the values of cells across rows and columns are meant to be equivalent, ensuring accuracy can be challenging, especially as the table grows. For instance, in a matrix where the A-B cell should match the B-A cell, discrepancies need to be flagged automatically. To tackle this efficiently, consider using a formula or script that dynamically verifies these relationships for all cells, eliminating the need for tedious manual checks and allowing for seamless updates as new rows are added.
I have a sheet formatted like the following, where the rows and columns have the same entries.
| A | B | C | |
|---|---|---|---|
| A | 0 | 1 | 4 |
| B | 1 | 0 | 2 |
| C | 4 | 2 | 0 |
In this, the value of the A-B cell should always be equal to the value of the B-A cell, and so forth. (Cells with the same row and column entry, ie A-A, will always be 0).
I'm looking for something that will verify that these values are equal, and flag when they aren't. More importantly, I want something that I don't have to do manually for a giant table that will probably have new rows added over time (which is why I'm not just making a set of =IF statements for every cell).
Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience