I have about 2500 rows and 7 columns of data A - G (text), each row of data should be the same information in each of the columns but as it turns out people have modified some data even when asked not to. In column H, I would like a formula to return the odd piece of data in each row, is this possible without resorting to VBA.
Column A is what the cells should be matched against as this was the original data.
Column A is what the cells should be matched against as this was the original data.
Last edited: