1 min readfrom 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

submitted by /u/Electric_Queen
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com