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

[µo°Ý] ½Ð°Ý¤j¤j­Ì ¦³Ãö¸ê®Æªº¦ê±µ±¡ªp

[µo°Ý] ½Ð°Ý¤j¤j­Ì ¦³Ãö¸ê®Æªº¦ê±µ±¡ªp

¦]¬°¥Ñ¹q¸£¨t²ÎÂà¥Xªº¸ê®Æ
¦ý¦ì¸m«o§¹¥þ¤£¬Û¹ïÀ³
¨D¸Ñ  ÁÂÁÂ

20160422word.jpg (32.05 KB)

20160422word.jpg

lo

http://blog.xuite.net/hcm19522/twblog/405374105

TOP

·PÁÂhcm19522ªº¦^µª
¦ýE2:E5{=IFERROR(INDEX(C:C,SMALL(IF(C$2:C$15="",ROW(C$2:C$15)),ROW(A1))-1),"")
³o¬q¤½¦¡½Æ»s¨ìE2:E5
¬OµL¤ÏÀ³ªº±¡ªp
©Î¬O§Ú¯à¤U¸ü±zªºEXCEL ÁÂÁÂ
lo

TOP

¥»©«³Ì«á¥Ñ °¶ÔÐ ©ó 2016-4-24 22:20 ½s¿è

¦^´_ 1# tr24572411

1.«ö[±`¥Î]¦A¿ï[¨ú¥N]
2.¥X²{[´M§ä¤Î¨ú¥N]µøµ¡
3.©ó[¨ú¥N]­¶¡A[´M§ä¥Ø¼Ð]¿é¤J (?)(^13)
4.[¨ú¥N¬°]¿é¤J \1
5.¤Ä¿ï[¨Ï¥Î¸U¥Î¦r¤¸]
6.[¥þ³¡¨ú¥N]
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 3# tr24572411

1.¿ïE2:E5
2.©ó¸ê®Æ½s¿è¦C¶K¤W¤½¦¡ =IFERROR(INDEX(C:C,SMALL(IF(C$2:C$15="",ROW(C$2:C$15)),ROW(A1))-1),"")
3.«öShiftÁä+CtrlÁä+EnterÁä  <==·|¦Û°Ê¥X²{¤j¬A¸¹
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

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