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

[µo°Ý] ¨Ì¸ê®Æ½d³ò¦C¼Æ¨M©w³Ì²×­pºâ­È

[µo°Ý] ¨Ì¸ê®Æ½d³ò¦C¼Æ¨M©w³Ì²×­pºâ­È

¥»©«³Ì«á¥Ñ sujane0701 ©ó 2016-10-20 00:54 ½s¿è

¦pªþ¥óÀÉ®×,½Ð¦Ñ®v­Ì«ü¾É
TEST.rar (11.2 KB) (ªþ¥óÀɤ£¤p¤ß­«ÂФW¶Ç¤£ª¾¦p¦ó§R°£,«D±`©êºp)

TEST.rar (11.2 KB)

¥ý¦bT3¿é¤J¤U¤½¦¡´ú¸Õ
=LOOKUP(1,0/C$1:C3,ROW()-ROW($1:3)+ MATCH(,0/((C4:C$99<>"")+(D4:D$99="")),))

³o¬O§A­n°£ªº¼Æ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

http://blog.xuite.net/hcm19522/twblog/459124623
°Ñ¦Ò ~

TOP

ÁÂÁÂML089ª©¥D¤Îhcm19522¤j¤j«ü¾É
ps:¬Q¤Ñ¥X®t­è¦^¨Ó,¦^ÂФӱß,«D±`¥¢Â§¤Î©êºp

TOP

¤@¤f®ð±o¨ì¤TºØ¤èªk,¤Ó´Î¤F,¤p§Ìªº°ÝÃD§¹¬ü¸Ñ¨M,¦A¦¸ÁÂÁÂML089ª©¥D¤Îhcm19522¤j¤j«ü¾É

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD