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

[µo°Ý] ¤â°Ê¿é¤J¤é´Á±a¥X§Ú­nªº­È¤ÎÄæ¦ì¤½¦¡¦Û°Ê»¼¼W

[µo°Ý] ¤â°Ê¿é¤J¤é´Á±a¥X§Ú­nªº­È¤ÎÄæ¦ì¤½¦¡¦Û°Ê»¼¼W

½Ð°Ý¦U¦ì°ª¤â
excel¥i¥H¦Û¦æ¿é¤J¤é´Á1~31¦Û°Ê±a¥X¼Æ­È¶Ü?
§Ú©È§Ú»¡©úªº¤£°÷²M·¡ §Ú§âÀɮשñ¤W¨Ó¨Ñ¤j®a°Ñ¦Ò

ÁÂÁ¤j®a

°ÝÃD.zip (17.2 KB)

¦^´_ 1# qq78787


    G1=VLOOKUP(E1,­Óªí!A4:AE65,31,FALSE)

    ³o¼Ë¶Ü¡H

TOP

¦^´_ 2# owen06

  ­è¨S¬Ý¨ì­Óªí¨ºÃä¤]¦³´£°Ý¡A
  AE4=SUM($U$4:$U4)/24/A4
  ©¹¤U©Ô§Y¥i¡C

TOP

¦^´_ 3# owen06

­ì¨Ó²Ä¤@­Ó°ÝÃD¥ÎVLOOKUP´N¥i¥H¸Ñ¨M¤F....§Ú¯u¬O·Qªº¤ÓÃø¤F
·PÁ§A

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD