[µ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

zheng211016

§A¸Õ¸Õ¬Ý¥i¤£¥i¥H:D

¤U¸ü (153.43 KB)

2017-9-23 22:32

­q-»s.zip (71.5 KB)

¤U¸ü¦¸¼Æ: 4

2017-9-23 22:32

013160

¦^´_ 2# zheng211016

½Ð°Ý¦pªG³o¤½¦¡§Ú¬O¿ù¦b­þ
=SUMPRODUCT((»s!D:D=A3)*(»s!B:B=B3)*»s!A:A)

¤U¸ü (12.23 KB)

2017-9-23 23:50

013160

§A¸Õ¸Õ¬Ý¥i¤£¥i¥H
zheng211016 µoªí©ó 2017-9-23 22:32

¦ý¬O§_ªG"»s"¤u§@ªí¤¤¦³­«ÂЪº«¬¸¹¬O§_§ì¨ú´N·|¿ù»~
©Ò¥H·Q­n³]¨â­Ó±ø¥ó­q³æ¸¹½X¸ò«¬¸¹¥h§ì¨ú»s¥O³æ¸¹

hcm19522

{=INDEX(»s!A$2:A$11,MATCH(A2&B2,»s!D$2:D$11&»s!B$2:B$11,))

013160

¦^´_ 5# hcm19522

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

¤U¸ü¦¸¼Æ: 2

2017-9-24 12:07

¸Õ¹L¤F¡A¦ý¥X¤£¨ÓÁٽФj¤jÀ°¦£

¤§«e¦³¤H±Ð§Ú¥Î¤U­±ªº¤½¦¡¡A¦ý¤£ª¾¹D­þ¸Ì¦³°ÝÃD¤]¬O¥X¤£¨Ó¡A¤£ª¾¹D¤j¤j¬O§_ª¾¹D
=SUMPRODUCT((»s!D:D=A3)*(»s!B:B=B3)*»s!A:A)

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

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

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

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),"")