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

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

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

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

Noname.jpg
2018-1-16 20:00


TEST.rar (8.67 KB)
Just do it.

¦^´_ 1# jsc0518

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

TOP

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

TOP

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

TOP

¦^´_ 4# zz5151353


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

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD