Hello, would be grateful if someone could help me here. I have 2 lists of
names in 2 different columns. one column has the names first and then last,
the other has the names last and then first. Ive used a foruma provided by
someone else on this site to reverse the order which works no problem. Now
however when i try and filter the names to compare which people are on both
lists, it doesnt return with any results, yet i know there are names which
appear on both lists. if anyone can help me i would reaaallly appriciate it.

Thanks
Gemma