B
Blake
I have a column of letters
u
o
u
u
o
The adjacent column also has letters, but it also has blank cells.
u
o
o
u
o
So it looks like something this:
u u
o
uo
u
oo
ou
I want to count the number of non matches. In the above example there
would be two. uo would be a non match as would ou. uu and oo are
matches and o-blank and u-blank are nothing.
I've tried all kinds of count ifs and sum ifs, but I haven't hit on
the right one.
Thanks
u
o
u
u
o
The adjacent column also has letters, but it also has blank cells.
u
o
o
u
o
So it looks like something this:
u u
o
uo
u
oo
ou
I want to count the number of non matches. In the above example there
would be two. uo would be a non match as would ou. uu and oo are
matches and o-blank and u-blank are nothing.
I've tried all kinds of count ifs and sum ifs, but I haven't hit on
the right one.
Thanks