ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] §PŪ´Á¼Æ_©¹¤W¶ñº¡

[µo°Ý] §PŪ´Á¼Æ_©¹¤W¶ñº¡

¥»©«³Ì«á¥Ñ papaya ©ó 2020-2-21 13:13 ½s¿è


§PŪ´Á¼Æ©¹¤W¶ñº¡.rar (6.79 KB)
K2
=IF(COUNTIF(B2:H2,I$1),A2,"")
KÄæ=B¡JHÄ榳Åã¥ÜI$1¼Æ¦rªºAÄæ´Á¼Æ

¤µ·QÅý´Á¼Æ©¹¤W¶ñº¡(¸Ô¦pLÄ浪®×)

½Ð°Ý¡JK2¤½¦¡À³¸Ó¦p¦ó­×§ï¡H
ÁÂÁ¡I

¦^´_ 1# papaya
1.K2¿é¤J
=IFERROR(OFFSET($A$1,SMALL(IF($B$2:$H$31=$I$1,ROW($B$2:$H$31)-1,""),ROW(A1)),),"")

2.CTRL+SHIFT+ENTER

TOP

¦^´_ 2# cucu
ÁÂÁ±zªºÀ°¦£©M«ü±Ð^^

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD