What's the best way to compare a range of cells on different rows?
For example, if the contents of the cells in the range a1:a5 are exactly the same as the range c1:c5 then execute code.
Previously i've compared cell a1 to c1 and if they match cell a2 to c2 and so on.
Surely i can compare the whole range in one go?
For example, if the contents of the cells in the range a1:a5 are exactly the same as the range c1:c5 then execute code.
Previously i've compared cell a1 to c1 and if they match cell a2 to c2 and so on.
Surely i can compare the whole range in one go?