Hi there,

I need to compare 2 sets of data and flag up where there is either a direct match or a close match. For example, I have a name and a city value in each data set;

Data Set 1:
Column A Column B
Aurélie Marsh Paris Cedex 02
Françoise Butt Lille Cedex
Andy Pitt Lille

Data Set 2:
Column A Column B
Aurelie Marsh Paris Cedex
Francoise Butt Lille
Barry Hurthly Paris

I would expect the Aurelie Marsh and Francoise Butt records to be flagged as a match even though the name are written with the extended character and the city is having almost the same value.

Is this possible? I don't want to take the data into Access unless I really have to, and I would like to avoid substituting the characters from the extended set.

Thanks for anything you can offer.