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

(¤w¸Ñ¨M)³o­Óif¥i¥H¬ð¯}¶Ü?

(¤w¸Ñ¨M)³o­Óif¥i¥H¬ð¯}¶Ü?

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

§Ú·Q­n§ì¨ú¨C­Ó²£«~³Ì·sªº­È
³o¬O§Ú¥Î¤À¬qµ²¨úªº¤è¦¡
¤£ª¾¹D¦³¨S¦³¤°»ò¤è¦¡¥u­n¿é¤Jµ²ªG¨º¤@ÄæÀx¦s®æ´N¦n
¤£¥Î¾aa b c d³o´XÄæ¥ý¥hÂ^¨ú­È

·s¼W Microsoft Excel ¤u§@ªí.rar (2.94 KB)

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

½T©wB:Y³£¬O¼Æ¦r¶Ü?
¦ÓAAÄæ´N¬O­n±o¨ì³Ì«áªº¼Æ­È¬O¶Ü?
¸Õ¸ÕAA3=LOOKUP(9.9E+307,$B3:$Y3)
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ª©¥D,  ½Ð±Ð,,, AA3=LOOKUP(9.9E+307,$B3Y3)
9.9E  ¥Nªíªº·N«ä,,,

TOP

9.9E+307¬°EXCEL®e³\³Ì¤j¼Æ­È
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½T©wB:Y³£¬O¼Æ¦r¶Ü?

½T©w³£¬O¼Æ¦r
¨S·Q¨ìlookup¥i¥H³o¼Ë¥Î
³oºØ¤è¦¡¤]¥i¥H¥Î¦bvlookup¤W­±¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

b3:y3 ¬O¾î¦Vªº, vlookup¬Oª½¦V,©Ò¥Hvlookup¥Î¤£¤W
¬Û¹ï»¡HLOOKUP¥i¥H¥Î¤W
=HLOOKUP(9.9E+307,B3:Y3,1,TRUE)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¶â
¤F¸Ñ
ÁÂÁ¤j¤jªº¸Ñµª
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD