I have two sets of address in two colums, I want to only look at those that
are different. First problem is some are the same but not entered exactly the
same.

If there is a was of counting the first say ten characters of colum a and
first ten of colum b and check if similar this would help.