|
[VIEWED 3932
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
ujl
Please log in to subscribe to ujl's postings.
Posted on 08-05-21 7:31
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
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!
|
| |
|
|
|
|
200times
Please log in to subscribe to 200times's postings.
Posted on 08-05-21 10:04
PM [Snapshot: 55]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
its easy just replace Joe Biden with Sleepy Joe.
|
| |
|
|
ehho2
Please log in to subscribe to ehho2's postings.
Posted on 08-05-21 11:03
PM [Snapshot: 73]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
= exact(columna, Columbia b) mah dwag on a new column
|
| |
|
|
ehho2
Please log in to subscribe to ehho2's postings.
Posted on 08-05-21 11:06
PM [Snapshot: 75]
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
Last edited: 05-Aug-21 11:39 PM
|
| |
|
|
