Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5938476
|
Quote:
Originally Posted by kccrow
You could also separate it into more columns if you want... such as...
Column B Formula =IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),"")
Column E Formula
=IFERROR(CONCATENATE(TEXT(LEFT(D2,FIND(",",D2)-1),""),", ",TEXT(LEFT(MID(D2,FIND(" ",D2)+1,256),1),"")),"")
Column G Formula
=IF(IFERROR(MATCH(IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),""),$E$2:$E$16,0),0)<>0,"On Roster","Not On Roster")
Looks like this:
|
That looks pretty good, however, I'm curious as to why Davids T isn't on the roster (Column G), even though the short names match?
|