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

013160

¤U¸ü (9.2 KB)
­q³æ

2017-9-23 14:19

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

¤U¸ü (12.99 KB)
»s¥O

2017-9-23 14:20

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

¤U¸ü (10.92 KB)
µ²ªG

2017-9-23 14:20

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

¤U¸ü¦¸¼Æ: 9

2017-9-23 14:18

013160

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

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

¤U¸ü¦¸¼Æ: 3

2017-10-21 18:29

¤U¸ü (25.92 KB)

2017-10-21 18:30

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

013160

¦^´_  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)

¤U¸ü¦¸¼Æ: 3

2017-10-21 18:09

¤U¸ü (42.41 KB)

2017-10-21 18:09

½Ð°Ý§Ú¤S­þ­ÓÀô¸`¥X¿ù¤F!?

joblyc017

¦^´_ 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

zheng211016

§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

013160

¦^´_ 9# zheng211016

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

¤U¸ü (8 KB)

2017-9-26 00:08

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

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

Hsieh

¦^´_ 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),"")

zheng211016

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

013160

¦^´_ 7# zheng211016


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

¤U¸ü¦¸¼Æ: 7

2017-9-24 23:20

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

¤U¸ü (15.15 KB)

2017-9-24 23:21

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

zheng211016

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

¤U¸ü¦¸¼Æ: 9

2017-9-24 15:55

¤U¸ü (72.52 KB)

2017-9-24 15:56