½Ð°Ý¡G±ø¥ó¬O¦¨¥ß«á¡A¨ú±oµo¥Í¦¸¼Æ

jsc0518

Dear ¥ý¶i,
1.Excelªí¤¤¡AAÄ欰¨C¦~¨C©u¡ABÄ欰¨ÑÀ³°Ó¡ACÄ欰¤À¼Æ
2.§Ú·Q¤U¤@­Ó¤½µø¦Û°Ê§ì¨ú¥X²{2017-Q4©Î¨ä¥L©u¸`®É¡A¤½¦¡À°§Ú§PÂ_¦b±ø¥ó2017-Q4¤U¡Aµo¥Í¤F´X¦¸¤À¼Æ¬O§C©ó50¥H¤Uªº

·PÁ¦U¦ì¡I

¤U¸ü (29.05 KB)

2018-1-16 20:00

TEST.rar (8.67 KB)

¤U¸ü¦¸¼Æ: 6

2018-1-16 20:01

jsc0518

¦^´_ 4# zz5151353


  ·PÁ±zªº«ü¾É¡AÁÂÁÂ:)

zz5151353

E2
{=INDEX(A:A,SMALL(IF(N(MATCH($A$2:$A$30&($C$2:$C$30<50),$A$2:$A$30&($C$2:$C$30<50),)=ROW($1:$29))*($C$2:$C$30<50),ROW($2:$30),4^8),ROW(A1)))&""}
F2
=IF(E2="","",SUMPRODUCT(($A$2:$A$30=E2)*($C$2:$C$30<50)))

jsc0518

¦^´_ 2# joblyc017
·PÁ±zªº«ü¾É¡ATEST OK¡I
Thanks!

joblyc017

¦^´_ 1# jsc0518

¬°¤F¤è«K°µ±Ð¾Ç¡A§R°£³¡¤À¸ê®Æ¤º®e¡A¤£¼vÅTµ²ªG
¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/CST2DJ
   

¤U¸ü (41.57 KB)

2018-1-16 20:44