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

[µo°Ý] ¡i¨D§U¡jExcel ¥[Á`¤£©T©wªº¼Æ­È

[µo°Ý] ¡i¨D§U¡jExcel ¥[Á`¤£©T©wªº¼Æ­È

¦U¦ìª©¤Í¦n,
§Ú¥Ø«e¹J¨ì¤@­ÓÃøÃD¡A³o°ÝÃD§Ú·Q¤F«Ü¤[ÁÙ¬OµL¸Ñ¡A©Ò¥H¤~·|µo¤å½Ð¨D¨ó§U

¦p¤U¹Ï¤@²Î­p¥X¨C­ÓÀ³¸Ó¦©°£ªº·~ÁZ¥ó¼Æ¡A¦ý¬O¦©°£³W«h¬O ¦©±¼·~ÁZÂI¼Æ§Cªº¥ó¡C
¹Ï¤G¬OROW Data
ªþ¥ó¤w¤W¶Ç
¹Ï¤@¡G

1.png
2015-1-29 14:47


¹Ï¤G¡G
2.png
2015-1-29 14:51


¬¡­¶Ã¯1.zip (10.28 KB)
Kenny

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-29 17:26 ½s¿è

¦^´_ 1# ky2599y
Àx¦s®æC2¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¿é¤J)
=SMALL(IF(¤u§@ªí2!$A:$A=¤u§@ªí1!$A2,¤u§@ªí2!$B:$B,""),1)
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212


    ÁÂÁ±zªº±Ð¾Ç¡A¦ý¬O¨C­Ó¤H¦©°£ªº¤£¤@¼Ë¡A¦³¤H­n¦©1µ§¡A¦³¤H­n¦©6µ§¡A³o¦³¸Ñ¶Ü
¦]¬°¦³50¦h¤H¡A¨C¦¸³£­n¤â¤u°µ....
Kenny

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-29 21:47 ½s¿è

¦^´_ 3# ky2599y
1¡B2#ªº¦^ÂеLªkº¡¨¬±zªº´Á«Ý¡A¨º1#¤¤ªº¡u¹Ï¤@²Î­p¥X¨C­ÓÀ³¸Ó¦©°£ªº·~ÁZ¥ó¼Æ¡A¦ý¬O¦©°£³W«h¬O¡y¦©±¼·~ÁZÂI¼Æ§Cªº¥ó¼Æ¡z¡C¡v¨s³º¬°¦ó¡H
2¡B¹Ï¤@ªºBÄæ¡uÀ³¦©¥ó¼Æ¡v¥ç¨Ó¦Û©óRaw Data?
¥i¥H´£¨Ñ¦³¡uµª®×¡vªºªþÀɨѰѡH

TOP

¦^´_ 4# p212

ÁÂÁ±zªº¦^ÂÐ
¦¨ÁZ»{¦C¦³¤@©wªº¦Ò¶q¡A¬G¥Ø«e°w¹ï¦U¦¨ÁZ¨Ó·½¦³¥[¤J¤W­­
IB+«D¶W¹L60%ªº´N·|¦©°£¡A¨C¥ó¦¨ÁZÂI¼Æ¦³°ª¦³§C¡A¥Ø«e¬O¿ï¾Ü¦©±¼ÂI¼Æ¤Öªº¹ï¦P¤¯¸û¦³§Q
QQ.zip (22 Bytes)
ªþ¥ó¤w¤W¶Ç
Kenny

TOP

¦^´_ 5# ky2599y
ªþ¥ó¬OªÅªº¡I
¥i¥H¦A¤W¶Ç¤@¦¸¡HÁÂÁ¡I

TOP

¦^´_ 6# p212


    OB Ratio.zip (98.55 KB)
©êºp¤w§ó¥¿ÀÉ®×
Kenny

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-30 15:34 ½s¿è

¦^´_ 7# ky2599y
½Ð°ÝªþÀÉ°ÝÃD¦b­þ¤@¤u§@ªí¤§­þ¤@Äæ¡H©Î­þ¤@¦C¡H¤Sraw data¦b­þ¨à¡H
5#°Ý¦ü¥G»P­ì°Ý1#ªº¤º®e¦³¨Ç«nÁÕ¥_Âá¡AÅý¤H¤V¤Gª÷­è¡A¤è«K¸Ô­z°ÝÃD¤@¦P¬ã¨s¡H
ÁÂÁ¡I

TOP

¦^´_ 8# p212


    Row ¦b¤u§@ªí3¡AµM«á·|¥ý¼Ï¯Ã¨ì¤u§@ªí¤G(ROW¬O«á¨Ó¥[¶i¥h¦a©Ò¥H¤u§@ªí2­Ó¬O¦­«e¶K¹L¥hªº¨Ã«D¼Ï¯Ã)
¤u§@ªí1 VLOOKUP ¤u§@ªí2 ¡A¨Ì³W½d­pºâªºµ²ªG¦bLÄd§Y¬°¨C¤H¶·¦©°£¤§¥ó¼Æ¡A
Á|¨Ò²Ä¤@¦ì
¶·¦©8¥ó¡A«h¥²¶·ºâ¥X¤u§@ªí3¤¤¡AÂI¼Æ(GÄd)³Ì¤pªº8¥ó
Kenny

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD