Excel Formula? - Sajha Mobile
SAJHA MOBILE
Excel Formula?
Posts 4 · Viewed 2997 · Go to Last Post
ujl
· Snapshot 0
Like · Likedby · 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
· Snapshot 55
Like · Liked by · 0
its easy just replace Joe Biden with Sleepy Joe.
ehho2
· Snapshot 73
Like · Liked by · 0
= exact(columna, Columbia b)

mah dwag on a new column
ehho2
· Snapshot 75
Like · Liked by · 0
Last edited: 05-Aug-21 11:39 PM
Please log in to reply to this post

You can also log in using your Facebook
View in Desktop
What people are reading
Visitor from US is reading Excel Formula?
Visitor from US is reading looking for friends/dates in KTM
Visitor from US is reading Mortgage lender
Visitor is reading Want Catering services from Nepalese?
Visitor is reading Business opportunity
Visitor is reading lost $3500 on penny stocks !!!
Visitor is reading रवि लामिछानेको व्यक्तिगत सम्बन्ध उठाएर चरित्र हत्या गर्ने दु
Visitor from US is reading Free VIN Check till 11/30/2013
Visitor from FR is reading COD MW3 on PS3
You might like these other discussions...
kale dai » pitambar
lost $3500 on penny stocks !!!
· Posts 2 · Viewed 88
wakeyour_mind » chicagoan
These Student Protests Against Israel Are the Most Important Political Movement of Our Lifetime
· Posts 3 · Viewed 215
NepalNews Sajha
News Summary from Nepal for Friday, April 26, 2024
· Posts 1 · Viewed 59
Lucky_Nepali » nash24
TPS advance parole Travel document i-131, Class of Admission ?
· Posts 2 · Viewed 284
Smriti-malla
मरेर गएनि कहिल्यै नमर्ने मान्छे!
· Posts 1 · Viewed 194
bandedv2023 » pitambar
ढ्याउ गर्दा दसैँको खसी गनाउच
· Posts 24 · Viewed 7467 · Likes 2
sm01234 » Logan
emergency donation needed
· Posts 26 · Viewed 2363 · Likes 5
Sajha Classifieds
Classifieds Summary: Room/Apt in MA
· Posts 1 · Viewed 94
NepalNews Sajha
News Summary from Nepal for Thursday, April 25, 2024
· Posts 1 · Viewed 114
forthecloset
10 Most popular sex toys hiding places
· Posts 1 · Viewed 203



Your Banner Here
Travel Partners
Travel House Nepal