Dear all
I have a huge list of names and surnames in column A and B. I need to compare their matches in column C and D.
What is an easy formula to use in columm E
To find any possible matches. Just a remark that names and surnames could be switched in a b c and d. So formula need to check any possible matches.
Thank you very much for your usual help
1. Please amend your profile to show you approximate location (country is fine).
2. Please update your profile to show your current Excel version. we have NO IDEA what you are using.
3. Please read the yellow banner (top of page) and post a small sample sheet.
4. Are you looking for EXACT matches or approximate matches?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks