JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,718
- Office Version
- 365
- Platform
- Windows
I have some tables that might have two or more columns with data that should be equal. Here is a simple example with small integers. Rows 6 & 9 have all equal values. In Row 7, Value3 is not equal. In Row 8, Value 2 is not equal. I will explain the "null parameter" comment shortly. In Row 10, Value4 is not equal. In Row 11, Value2 is flagged, but it is Value1 that is not equal. This is because the code that does this compares the first value t all of the rest.
The next 3 mini-sheets demonstrate the code in the table above and two others with different types of data.

The next 3 mini-sheets demonstrate the code in the table above and two others with different types of data.