Quote:
Originally Posted by C3HIEF3S
Can you post an example of some of the rows in the columns that you’re working with and what you want your end-result to be?
|
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?