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

[µo°Ý] §ì¨ú¸ê®Æ

[µo°Ý] §ì¨ú¸ê®Æ


­q³æ¸¹½X¥u¦³¤@­Ó
«¬¸¹¦³¦h­Ó

»s¥O³æ¸¹½X¥u¦³¤@­Ó
«¬¸¹¦³¥i¯à¬O¦h­Ó¤]¥i¯à¥u¦³¤@­Ó

·Q¦b"­q"¤u§@ªí¤¤¦h¤@­ÓÄæ¦ì©ñ»s¥O³æ¸¹½X
¤£ª¾¹DÀ³¸Ó­n¦p¦ó¼g¤J¤½¦¡©Îµ{¦¡
­q-»s.rar (10.27 KB)

¦]¬°§A¥þ³¡³£§ìB2&C2 = =
zheng211016 µoªí©ó 2017-9-25 12:54



«¬¸¹­«ÂÐ.rar (445.35 KB)

³o¤S¬O«ç¤@¦^¨Æ!?
¦³ªº¦³¥X²{¦³ªº¨S¥X²{!?

TOP

¦^´_  013160

    =SUMPRODUCT((»s!D=A3)*(»s!B:B=B3)*»s!A:A)

ª½±µ»PAÄæ¬Û­¼·|¥X²{¿ù»~¡A¬O¦]¬°A ...
joblyc017 µoªí©ó 2017-9-30 12:02



­q³æ-­q³æ³æ¸¹-©ú²Óªí.rar (477.05 KB)
½Ð°Ý§Ú¤S­þ­ÓÀô¸`¥X¿ù¤F!?

TOP

¦^´_ 6# 013160

    =SUMPRODUCT((»s!D:D=A3)*(»s!B:B=B3)*»s!A:A)

ª½±µ»PAÄæ¬Û­¼·|¥X²{¿ù»~¡A¬O¦]¬°A1ªº¡u»s¥O³æ¸¹¡v¬°¤å¦r¡A¤£¯à°µ¹Bºâ¡F
¦ÓA2:A11ªº®æ¦¡³]©w¦¨¤å¦r«¬ºA¡A¬G¤]¤£¯à°µ¹Bºâ

Âà´«¦¨¼Æ­È«¬ºA¡A¥i¥H¨Ï¥ÎVALUE¨ç¼Æ¡A©ÎªÌ¬O¥[¤W¨â­Ó­t¸¹¡A¨Ò¦p¡G
¤èªk¤@¡BVALUE(A2)
¤èªk¤G¡B--(A2)

­Y·Q¥HSUMPRODUCT¨ç¼Æ±a¥X»s¥O³æ¸¹¡A½Ð°Ñ¦Ò https://goo.gl/sSEvVZ

TOP

¥»©«³Ì«á¥Ñ zheng211016 ©ó 2017-9-26 00:46 ½s¿è

§A¥ý½Æ»s¨ä¤¤¤@­Ó
µM«á§â¾ã±Æ¬å±¼
¦A­«·s¿é¤J °O±o ³Ì«á¦A¥[¤W°}¦C¤½¦¡
µM«á¬Ý§A¦Û¤v­n´X¦æ´N¦Û¤v©¹¤U©Ô

https://support.office.com/zh-tw/article/%E9%99%A3%E5%88%97%E5%85%AC%E5%BC%8F%E7%9A%84%E8%A6%8F%E5%89%87%E5%92%8C%E7%AF%84%E4%BE%8B-7d94a64e-3ff3-4686-9372-ecfd5caa57c7

TOP

¦^´_ 9# zheng211016

¹ï§q¨Sª`·N¨ì
­è­n§ï«o¥X²{¥H¤U°T®§

Â^¨ú.PNG
¤£¥i¥Hª½±µ§âA2 §ïA3 B2§ïB3!?
§Oªº¤½¦¡¥iª½±µ§ï¤@¨â­Ó«áÂI¨â¤U´N·|¦Û°ÊÅÜ¡A¬°¦ó³o¤£¥i¥H!?

SORRY¡A°ÝÃD¦³ÂI¦h

TOP

¦^´_ 1# 013160

F2=IFERROR(LOOKUP(2,1/(»s!$D$1:$D$65536&»s!$B$1:$B$65536=­q!A2&­q!B2),»s!$A$1:$A$65536),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ zheng211016 ©ó 2017-9-25 12:57 ½s¿è

¦]¬°§A¥þ³¡³£§ìB2&C2 = =

TOP

¦^´_ 7# zheng211016


    «¬¸¹­«ÂÐ1.rar (10.09 KB)
¤£¦n·N«ä§Ú¸Õ¤F¡A¦ý«o¥X²{¬Û¦Pªº¸¹½X!?
¬O§_¥i¸ÑÄÀ¤@¤U§Ú¬O¨º­ÓÀôµ²¥X¿ù¤F


·PÁ§A­ÌµL¨pªºµªÂÐ

TOP

hcm19522 ¤j¤j¬O¹ïªº­ò!!!
¥u¬O§A¤£ª¾¹D¥L¬O°}¦C¤½¦¡
«¬¸¹­«ÂÐnew.zip (11.69 KB)

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD