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

[µo°Ý] ²Î­p²Ö­p¦¸¼Æ°ÝÃD

[µo°Ý] ²Î­p²Ö­p¦¸¼Æ°ÝÃD

1.( H2Äæ¦ì) Åã¥Ü¥ªªí®æ AB001 ¾÷¥x ¦³¥X²{"Down"  ²Ö­p¦¸¼Æ
2.( H3Äæ¦ì) Åã¥Ü¥ªªí®æ AB001 ¾÷¥x ¦³¥X²{"ÅçÃÒ" ²Ö­p¦¸¼Æ
3.( H4Äæ¦ì) Åã¥Ü¥ªªí®æ AB001 ¾÷¥x ¦³¥X²{"§ï¾÷" ²Ö­p¦¸¼Æ
4.( I2Äæ¦ì) Åã¥Ü¥ªªí®æ AB002 ¾÷¥x ¦³¥X²{"Down"  ²Ö­p¦¸¼Æ
5.( I3Äæ¦ì) Åã¥Ü¥ªªí®æ AB002 ¾÷¥x ¦³¥X²{"ÅçÃÒ" ²Ö­p¦¸¼Æ
6.( I4Äæ¦ì) Åã¥Ü¥ªªí®æ AB002 ¾÷¥x ¦³¥X²{"§ï¾÷" ²Ö­p¦¸¼Æ
¦pªþ¥ó©Ò¥Ü
½Ð°Ý¦U¦ì¤j­ô¦p¦ó³]©w?

²Ö­p¦¸¼Æ°ÝÃD.zip (15.18 KB)

¦^´_ 1# jeff5424


  H2=COUNTIFS($A$2:$A$50,H$1,$E$2:$E$50,"*" & $G2 & "*")    ¥k©Ô¤U©Ô
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 2# n7822123
·PÁ¤j¤jªºÀ°¦£
¸g´ú¸Õ¥i¥¿±`¨Ï¥Î...ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD