201803100935找出相同資料對應欄 ,需二人以上 (4150)

H7:H17{=IF((SUM(IFERROR(1/COUNTIFS(E$7:E$17,E$7:E$17,F$7:F$17,F$7:F$17),)*(E$7:E$17=E7))>1)*(MATCH(E7&F7,E$7:E$17&F$7:F$17,)=ROW(A1)),ROW(),"")

J7:K13{=IFERROR(INDEX(E:E,SMALL($H$7:$H$17,ROW(A1))),"")

回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite