Quote:
Originally Posted by Coach
See attached.
As you can see, the left would have the full name while on the right, some will already have a full name (which can be easily found by using the conditional format for duplicate values). Others will have a partial due to missing middle initial/name or partial first name.
My end result would be is to find column A (which is like roughly 25-50 names) and on column C, it would have a complete roster of who joined (in excess of 700 names), in a yearly cycle.
Basically, I just want to find a functional or something that allows me to find the person's full name on the left to have a probability of matching the name on column C.
For example, Feunutes, Shannon Arnold on the left is Feunutes, S. But because of Column C is larger, I don't want to have to use search and find each individual names independently/manually, if that makes sense?
|
I'll put something together for you but you're not really going to be able to get a near match. What you'll have to ensure that at least the portion of LastName, FirstInitial is in both and you could get something reasonable using a combination of a column with a LEFT/FIND based formula and then a INDEX/MATCH based formula.