單格多數 取出排序 (12936)

D2=TEXT(LARGE((0&TRIM(MID(SUBSTITUTE(B$2:B$5,",",REPT(" ",99)),COLUMN(A:I)*99-98,99)))*1,ROW(A1)),"0;;")

E2=IF(D2="","",LOOKUP(1,0/FIND(D2,B$2:B$5),$A$2:$A$5))