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

[µo°Ý] ½Ð°Ý¦p¦ó¥Î¤½¦¡©â¨ú¦³¸ê®ÆªºÀx¦s®æ©O¡H

[µo°Ý] ½Ð°Ý¦p¦ó¥Î¤½¦¡©â¨ú¦³¸ê®ÆªºÀx¦s®æ©O¡H

¦U¦ì¦n¡A§Ú²{¥¿°µªºEXCEL¤¤»Ý­n§â«ü©w½d³ò¤ºªºÀx¦s®æ¤¤©â¨ú«DªÅ¥ÕªºÀx¦s®æ¸ê®Æ¡C
½Ð°Ý§Úªº¤½¦¡À³¸Ó¦p¦ó¼g©O¡H

¨Ò¦p¡G§Ú­n©â¨ú B2:S2 ¤¤©Ò¦³ªº«DªÅ¥ÕÀx¦s®æªº¸ê®Æ¨ì B6:S6¡C(¨£ªþ¥ó)


·Ð½ÐÀ°¦£¡A·P¿E¸U¤À~

¦^´_ 1# yeeki

B6Àx¦s®æ°}¦C¤½¦¡(Ctrl+Shift+Enter¿é¤J)
  1. =IFERROR(INDEX(2:2,,SMALL(IF(ISBLANK($B2:$S2),"",COLUMN($B2:$S2)),COLUMN(A1))),"")
½Æ»s¥N½X
¤U©Ô¥k©Ô
­Y¬O2003¥H«eªºª©¥»¨S¦³IFERROR¨ç¼Æ¡A¥i§ï¬°IF(ISERROR(­ì¤½¦¡),"",­ì¤½¦¡)

TOP

¦^´_ 2# Bodhidharma


    ±z¦n¡A°ÝÃD¤w¸Ñ¨M¡A·PÁÂÀ°¦£:loveliness:

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD