You might also be interested in
Replies (1)
Please login or register to join the discussion.
Comparing a list of Values in a column
ABCDEFGLong HorneHSD3Trad. Brick1919-1944 £ 48,000 67.33Long HorneHSD3Trad. Brick1919-1944 £ 48,000 65.30Long HorneHSD3Trad. Brick1919-1944 £ 48,000 67.33Long HorneHSD3Trad. Brick1919-1944 £ 48,000 67.33Long HorneHSD3Trad. Brick1919-1944 £ 48,000 67.33Long HorneHSD3Trad. Brick1919-1944 £ 48,000 67.33
I have been trying to use =OR(EXACT(A1, A2:A7) to test if all cells in the column are the same/equal. I am checking for rent anamolies in col G. It seems to say TRUE if only one value is the same as the TestValue
The condition is if cells in each Col (A to F) are the same then the values in Col G should be all be the same. I am working on long spreadsheet (7.5k rows) and have grouped all similar properties together based on values in Col A to F.
I want to check each column to get a True or False answer, that all values are the same/equal.