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

[µo°Ý] ½Ð°Ý¤@¤U¡A¤ñ¹ïªº°ÝÃD...¦pªþ¥ó¡]¤w¸Ñ¨M¡^

[µo°Ý] ½Ð°Ý¤@¤U¡A¤ñ¹ïªº°ÝÃD...¦pªþ¥ó¡]¤w¸Ñ¨M¡^

¥»©«³Ì«á¥Ñ turbine ©ó 2012-3-13 08:12 ½s¿è

aÄæ¤ÎbÄ欰¤@¤p®É«e¤Î¤@¤p®É«áªºsensor²§±`³qª¾
½Ð°Ý¸Ó«ç»ò¦bcÄæ¦Û°Ê±a¥X³o¤@¤p®É¤ºªº²§±`sensor¸¹¶Ü¡H
dÄæ¤ÎcÄæ¤]¬O¤@¼Ëªº¡A½Ð¦U¦ì¤j¤j¤£§[«ü¾É¡AÁÂÁ¡C
°ÝÃDÀÉ1.zip (3.2 KB)

¦^´_ 1# turbine
C2=IF(IF(A2="",1,COUNTIF(B:B,A2))=0,A2,"")&IF(IF(B2="",1,COUNTIF(A:A,B2))=0,B2,"")

°ÝÃDÀÉ1.zip (5.46 KB)

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-3-12 22:48 ½s¿è

¦^´_ 1# turbine
©w¸q¦WºÙ
x=SMALL(IF(COUNTIF(rng,rng)=1,ROW(rng)*10+COLUMN(rng),""),ROW(Sheet1!$A1))
y=SUMPRODUCT((COUNTIF(rng,rng)=1)*1)
rng=OFFSET(Sheet1!C$2,,-2,COUNTA(Sheet1!A:A)-1,2)

°ÝÃDÀÉ1.zip (45.14 KB)
C2¤½¦¡=IF(ROW(A1)>y,"",INDIRECT("R"&(x-MOD(x,10))/10&"C"&MOD(x,10),0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«z³á~~~
ÁÂÁÂr¤j¤Îª©¥Dªº¸Ñµª~~~
ª©¥D³oÃä¥Î¤F³\¦h¨ç¼Æ³£¤£À´...
§V¤O¾Ç²ß¤¤¡I
ÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD