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

[µo°Ý] ¸ê®Æ¾ã²z

§Q¥Î"¿ï¾Ü¶K¤W"¥\¯à§Y¥ix,yÅÜ´«¡C
Mark Wang

TOP

ANGELA  ¤j·Q½Ð±Ð¬°¦ó§Ú¨Ï¥Î±z©Ò´£¨Ñ¤§°}¦C¤½¦¡±a¥X¨Óªº¬OªÅ¥Õ©O?
³Â·Ð±z¦b±Ð¾Ç¤@¤U¡AÁÂÁÂ!!
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

°}¦C¤½¦¡­n¥ÎCTRL+SHIFT+ENTER ¤@°_¿é¤J
·|¦Û°Ê²£¥Í¤j¬A¸¹§â¤½¦¡¥]°_¨Ó.
¦]¬°§A¨Sªþ¥[EXCELÀÉ,©Ò¥H§Úªº¤½¦¡¬O¨Ì·Ó7f¹Ï¤ù¦ì¸m¨Óªº.½Ð°Ñ¦Ò«á­×§ï.

TOP

¤j¤j±z¦n~~§Ú±NÀɮפW¶ÇÂP~~¦b³Â·Ð±z¤F~~ÁÂÁÂ

TEST.rar (51.04 KB)

80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 5# dragonbx

1000­Ó®Æ¸¹¡A¤u§@ªí¥u¦³256Äæ
§A¯àÂà¸m¹L¨Ó¶Ü?
ANGELAª©¥Dªº¤½¦¡¬O®Æ¸¹ªºX­È²M³æªº¤½¦¡
§A¥²¶·¦bE1¶}©l¿é¤J§Aªº®Æ¸¹
E1°}¦C¤½¦¡
=IF(COLUMN(A$1)>SUM(1/COUNTIF($B$2:$B$45,$B$2:$B$45)),"",INDEX($B:$B,SMALL(IF($B$2:$B$45<>$B$3:$B$46,ROW($B$2:$B$45),""),COLUMN(A$1))))
E2¿é¤J¸Ó¤½¦¡¡A¦V¤U½Æ»s

¨Ã¤£«Øij¨Ï¥Î°}¦C¤½¦¡¸Ñ¨M
ÁÙ¬O¥Î¼Ï¯Ã¸Ñ¨M¨Óªº«ê·í
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 16# Hsieh

¦]¬°§Ú±N¦¨¦¡§@¤F­×§ï¡A§ï¦¨©Ò¥H®Æ¸¹³»¦h¤£¶W¹L100µ§ªº¤è¦¡
¬°¦ó¤£¥Î¼Ï¯Ã¡A¬O¦]¬°¼Ï¯Ã¦³¨Ç¥\¯à·|³y¦¨§Ú«á­±ªº¥¨¶°µLªk°õ¦æ
©Ò¥H¥²¶·¨Ï¥Î±ø¦C¦¡§e²{¡A§Ú¸Õ¹L¤j¤j©Ò­z¥i¬O²Ä¤G¦æ¶}©l´N·|¥X²{#NUM!
¬O§Ú­þ¸Ì¿é¤J¿ù»~¤F¶Ü?

test.jpg (120.85 KB)

test.jpg

80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¬JµM¥Î¨ì¥¨¶°¬°¤°»ò¤£°®¯Ü³£¥Î¥¨¶°©O¡H
³o¼Ë¥[¤W³\¦h¤½¦¡·|Åý§Aªº¥¨¶°¶]¤£°Ê

TOP

¤p§Ì¥\¤O¤£¨¬~~¶È¯à°÷¨Ï¥ÎªF´ê¦è´êªk§¹¦¨§Úªº»Ý¨D~~@@
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

§Ú§ä¨ì°ÝÃDÂI¤F¡A­ì¨Ó¬O§Ú§Ñ°O¥Î°}¦C¤F~·PÁ¤j¤j­Ìªº¼ö¤ß«ü¾É­ò
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 16# Hsieh


    ¤j¤j±z©Ò´£¨Ñªº¤½¦¡§Ú¤µ¤Ñ´ú¸Õ¤F¡A±z­ì¥ý¹w³]ªº¤ñ¼Æ¬°45¦pªG§Ú²{¦b¤ñ¼Æ¦³¨ì¹F150µ§®É
·|Åã¥Ü#DIV/0 §Ú¦³­×§ï BÄæ¦ìªº­È¤§«á´N¥i¥H¥¿±`¨Ï¥Î¤F¡A½Ð°Ý¥i¥H¤£¥ÎÅܧóBÄæ¦ì´N¥i¥Hª½±µÅã¥Ü©O?

=IF(COLUMN(A$1)>SUM(1/COUNTIF($B$2:$B$45,$B$2:$B$45)),"",INDEX($B:$B,SMALL(IF($B$2:$B$45<>$B$3:$B$46,ROW($B$2:$B$45),""),COLUMN(A$1))))
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD