取值欄均出現數字 取出 (14138)

AM=IFERROR(LOOKUP(1,0/(MMULT(1-ISERR(FIND(","&TRIM(MID(SUBSTITUTE(AO$2:AO$14,",",REPT(" ",19)),{1,2,3,4}*19-18,19))&",",","&N1&",")),{1;1;1;1})=LEN(AO$2:AO$14)-LEN(SUBSTITUTE(AO$2:AO$14,",",))+1),AO$2:AO$14),)



留言