•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 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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#row zero
#real-time data collaboration
#financial modeling with spreadsheets
#real-time collaboration
#Excel alternatives
#checksum
#equivalent cells
#A-B cell
#B-A cell
#table
#values
#verify
#flag
#equal
#giant table