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?
|
Column B Formula: =IF(IFERROR(MATCH(IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),""),$D$2:$D$16,0),0)<>0,"On Roster","Not On Roster")
Column D Formula: =IFERROR(CONCATENATE(TEXT(LEFT(C2,FIND(",",C2)-1),""),", ",TEXT(LEFT(MID(C2,FIND(" ",C2)+1,256),1),"")),"")
What it will look like...