Forum Discussion
Help with comparing columns matches
I'm betting this is an easy one, but I can't figure it out. I have a large sheet with 3 columns. Going from left to right each column will have something from the column on its left but some extra ...
Thanks that kind of works. It does match cells from col A to B to C but it also seems to be missing some.
Take a look at the attached in column D I've put a ? next to a row I expected to match. Row 4, 5 and 9 I would expect the cell in col C to be formatted. Row 7 col C also matches cells in row 8 col A and B. Row 9 i expected B9 to also be formatted matching A9 but it's not. I check formatting etc can't find why it won't match.