名簿の名字を操作

=IF(COUNTIF($B$4:$E$200,LEFT(E4,FIND(" ",E4))&"*")>1,4&SUBSTITUTE(LEFT(E4,FIND(" ",E4)+1)," ",""),4&LEFT(E4,FIND(" ",E4)-1))

=IF(COUNTIF($B$4:$E$200,LEFT(C4,FIND(" ",C4))&"*")>1,2&SUBSTITUTE(LEFT(C4,FIND(" ",C4)+1)," ",""),2&LEFT(C4,FIND(" ",C4)-1))

=IF(COUNTIF($B$4:$E$200,LEFT(D4,FIND(" ",D4))&"*")>1,3&SUBSTITUTE(LEFT(D4,FIND(" ",D4)+1)," ",""),3&LEFT(D4,FIND(" ",D4)-1))

=IF(COUNTIF($B$4:$E$200,LEFT(E4,FIND(" ",E4))&"*")>1,4&SUBSTITUTE(LEFT(E4,FIND(" ",E4)+1)," ",""),4&LEFT(E4,FIND(" ",E4)-1))