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

[µo°Ý] (¤w¸Ñ¨M)Àx¦s®æ¥i¥H³]¤½¦¡§ì¤u§@ªí¦WºÙ¶Ü

[µo°Ý] (¤w¸Ñ¨M)Àx¦s®æ¥i¥H³]¤½¦¡§ì¤u§@ªí¦WºÙ¶Ü

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:25 ½s¿è

C6ªºÀx¦s®æ¤¤ªº=COUNTIF('0903'!$B$3:$H$50,$B6)
0903¥i¥H³z¹L²Ä5¦æ¤¤ªº¤º®e¥h§ì¥h¤u§@ªí¶Ü
³o¼Ë²¾¨ìD¥H«áªºÄæ¦ì´N¤£¥Î¦b­×§ï¤½¦¡
¤£ª¾¹D³oºØ·Qªk¥i¤£¥i¥H¹ê²{

Doc1.rar (123.12 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

ÁÂÁ  oobird  ¤Î et5323 ¤j¤j
§ÚÁÙ¬O²Ä¤@¦¸¥Î INDIRECT
¨S·Q¨ì³o»ò¦n¥Î
¤£¹L§Úcopy  et5323 ¤j¤jªº·|¥X²{¿ù»~
copy oobird¤j¤jªº´N¨S°ÝÃD
¬O®æ¦¡ªº°ÝÃD¶Ü
¦]¬°¬Ý¤½¦¡¤º®e¥u¦³®t¤@­Ó$ ¨ä¥L¤º®e³£¨Ì¼Ë ¤å¦r¦³¨Ç¤£¤@¼Ë
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 5# Hsieh


  µ´¹ï°Ñ·ÓªºÆ[©À§Úª¾¹D
§Ú¬O¦b²Ä¤@®æÀx¦s®æ´N¥X¿ù¤F
¯u©Ç
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

Ãø©Ç
ÁÂÁ³á
·Q»¡¦³¤£¤@¼Ë
¥i¬O¤S¤£ª¾¹D­þ¸Ì¤£¤@¼Ë
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD