如图所示,查找数字“9”对应的序号,正确序号应为:1、5、9。请问如何用公式来查找?
2021版,在G5中输入或复制粘贴下列公式
=FILTER(A:A,B:B=F5)
或
=FILTER(A$2:A$14,B$2:B$14=F5)
=IFERROR(INDEX(SMALL(IF(ISNUMBER(FIND("A"&$D$2&"A","A"&$B$2:$B$13&"A")),$A$2:$A$13,""),ROW(A1)),),"")
CTRL+SHIFT+回车