同開頭指定 取字符最長 (15286)

C2{=IFERROR(INDEX(G:G,RIGHT(LARGE(IF(1-ISERR(0/(FIND(G$2:G$9,"@"&B2)=2)),LEN(G$2:G$9)/1%+ROW($2:$9)),1))),"X")