ªð¦^¦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¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD