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

[µo°Ý] ¦hÄæ¸ê®Æ¬d¸ß¨ç¼Æ³]©w°ÝÃD

[µo°Ý] ¦hÄæ¸ê®Æ¬d¸ß¨ç¼Æ³]©w°ÝÃD


¦­¦w
·Q½Ð°Ýª©¤Wªº°ª¤â­Ì
§Úªº¤u§@ªí"FT" ·Q³]©w§Úµ¹«È¤Hªº³õ¤º ³õ¥~FREE TIME®É¶¡
´N¬O§Ú±NÂd¸¹KEY¶iC2«á ,C3©MC4 ¯à°÷¬d§ä¨Ã¦^¶Ç IÄæ ©M JÄæ ªº°T®§¤À§O¶Ç¨ìC3¸òC4
¦ý¸ê®Æ¨Ó·½¬O¦bK:V
¦pªG¥u¥ÎINDEX ©MMATCH §Ú¥u¦³¿ìªk³]©w¦¨¤@Äæ¤@Äæ ¬d§ä
·Q½Ð°ÝC2ªº¨ç¼Æ¸Ó¦p¦ó³]¸m?
µM«á¦pªG¿é¤JÂd¸¹¦³­«½Æ §Æ±æ¯à°÷§ì¨ì³Ì¶i¤@µ§ªº®É¶¡
¨Ò:K13©MK17Âd¸¹³£¬OCAIU12346678
¦pªG±N³o­ÓÂd«á¿é¤J·j´M«á¸õ¥Xªº³õ¤ºÀ³¸Ó¬°12/20 (I17®æ) ,¦Ó¤£·|¸õ¨ì10/13 (I13®æ)
ªþ¤Wªþ¥ó
·PÁÂ


FT.zip (13.21 KB)
1.PNG
2019-12-11 07:56

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


    ÁÂÁÂhcm¤j
¦ý¤£¦n·N«ä¥i¥H½Ð°Ý¤@¤U³o­Ó¨ç¼Æ¸Ó«ç»ò¶K¤W¥h¨Ï¥Î¶Ü
¨S¥Î¹L°}¦C ¤£·|³]©w:(

TOP

¦^´_ 3# a38480912


    ¼Æ²Õ¤½¦¡ :½Æ»s¤½¦¡ ¤£§t "=" ,¶K¤W«á¥[ "="   ;³Ì«e "{" ¥Nªí shift+ctrl+enter ¤TÁä¤@°_«ö©Ò²£¥Í ,«Dµ{¦¡¸Ì­±
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-12-12 15:27 ½s¿è

C3:
=IFERROR(1/((C2<>"")/MMULT(1,MAX(I13:I99*(MMULT(N(K13:V99=C2),ROW(1:12)^0)>0)))),"")

C4:
=IF(C3="","",LOOKUP(1,0/(I13:I99=C3)/(MMULT(N(K13:V99=C2),ROW(1:12)^0)>0),J13:J99))

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD