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

[µo°Ý] (¤w¸Ñ¨M)vlookup »P offset ¦³®t²§¶Ü?

[µo°Ý] (¤w¸Ñ¨M)vlookup »P offset ¦³®t²§¶Ü?

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

¦pªþ¥[ÀÉ ´¡¤Jµù¸Ñªº³¡¤À
¬°¤°»ò§Úªº®É¶¡¬O½Æ»s¹L¥h¥i¬O¥Îvlookup¥L»`´M¥X¨Ó·|¬Ona
¥i¬O¥Îoffset´N¥i¥H¥X²{§Ú­nªº©O?

¦æ¨Æ¾ä.rar (16.13 KB)

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

¹ï¤£°_À³¸Ó¬O¨â­Ó³£¤£¥i¥H
offsetªº¨ç¼Æ§Ú¥´¿ù¤F
¦pªG³Ì«á­±widthÀ³¸Ó¬°0
¬°¦ó©ú©ú¬O½Æ»sªº¸ê®Æ¥Îvlookup ¤Î offset·j´M³£§ä¤£¨ì¸ê®Æ©O
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 2# freeffly


¤£¤@©w­n¨Ï¥Îvlookup,offset
¥Îcountif·|§ó³æ¯Â
F3=IF(F$2=NextWorkDay(F$2-1,1),IF(OR($A3="12¡G00~12¡G30",$A3="12¡G30~13¡G00"),"¥ð®§",IF(COUNTIF(¤u§@®É¶¡!$A$2:$A$17,'0903'!$A3),"¤W¯Z","")),"")
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 3# asimov


    ³o¼Ëªº½T¬O¦³¸Ñ¨M§Úªº°ÝÃD
   ¤£¹L§Ú«Ü¦n©_¬°¤°»òvlookup ¸ò offset·|¥¢®Ä
   ¹J¨ì³o±¡§Î§Ú³£·|¨Ï¥Î³o¨âºØ¤Ï¦Ó¤£·|·Q¨ìcountif
     ¸£µ¬ªGµM­n§óÆF¬¡
   ÁÂÁ³á
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¨Ï¥ÎCOUNTIF¯uªº¬O¤£¿ùªº¿ï¾Ü
·PÁ¤À¨É

TOP

¹ï°Ú..¬°¤°»ò§Ú¤]¬O²Ä¤@·Q¨ìªºÁ`¬Ovlookup¦Ó¤£¬OCOUNTIF?
­È±o¾Ç²ß

TOP

°ÝÃD¥X¦b~ªi®ö²Å¸¹
ªi®ö²Å¸¹¦b´M§ä¨ú¥N®É
¥²¶·¨Ï¥Î2­Ó~~¤~¯à§ä¨ì
EXCEL»¡©ú:
¦pªG­n´M§ä¤u§@ªí¸ê®Æ¤¤ªº¬P¸¹¡B°Ý¸¹»Pªiª¬²Å¸¹ (~)¡A¥i¥H¦b [´M§ä¥Ø¼Ð] ¤è¶ô¤¤¿é¤Jªiª¬²Å¸¹°µ¬°´M§ä¥Ø¼Ðªº«e¸m¦r¤¸¡C¨Ò¦p¡A­Y­n´M§ä¥]§t "?" ªº¸ê®Æ¡A¥i¥H¿é¤J¡u~?¡v°µ¬°·j´M·Ç«h¡C
±N¸ê®Æ¤¤ªº~¨ú¥N¦¨-´N¥i¥H§ä¨ì¤F
©Ò¥H²Ä¤@­Ó·Q¨ì¥ÎÀ˵ø»P°Ñ·Ó¨ç¼Æ¨Ó¸ÑÃD¬O¨S¦³¿ùªº
¥u¬O°w¹ï­Ó§O¸ê®ÆµLªk¹F¦¨®É¡A´N¥h¤F¸Ñ°ÝÃD©Ò¦b¡A¦A¥h«ä¦Ò¸Ñ¨M¤§¹D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD