Hi Sajha Folks, I have two cloumns A & B with last name first, and then first name. For example: Biden, Joe. Now, I am trying to find if the name that appears in column A also appears in column B. Also, column B may be missing middle initial for some of the names. I do not want to manually look up as it will take a lot of time. Is there a formula that I can use? If the closest match is found, it can either give me a true value or the name itself. Thanks in advance!
ujl · Aug 5, 2021 7:31 PM · 12,144 views
its easy just replace Joe Biden with Sleepy Joe.
200times · Aug 5, 2021 10:04 PM
= exact(columna, Columbia b) mah dwag on a new column
ehho2 · Aug 5, 2021 11:03 PM
Last edited: 05-Aug-21 11:39 PM
ehho2 · Aug 5, 2021 11:06 PM
This conversation is preserved exactly as it was on the original Sajha.com and can't accept new replies.
Start a New Discussion