每行最多出現 取對應值 (13945)

C2=IFERROR(INDEX(E:E,RIGHT(TEXT(MAX(MMULT(COUNTIF(B2,"*"&F$2:H$4&"*")*(F$2:H$4<>""),{1;1;1})/1%+{2;3;4}),"[>10]0;"),2)),"無值")