Can I compare 2 columns (that are not side by side) and return a count of the number of times they differ?
ie
apples pears
apples apples
apples cherries
apples apples
would return a count of 2..?
I need this to be a formula in one cell, with an answer showing in that cell.
This may be basic stuff, but that's my level!!!
Thanks,
Tim![]()
Bookmarks