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

[¤À¨É] ­«½Æ¤H¦Wªí

[¤À¨É] ­«½Æ¤H¦Wªí

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-4-7 16:13 ½s¿è

­è­èÀ³¥Î·s¾Ç¨ìªº¤èªk¼g¤F¤@­ÓªF¦è¡G
¦³¤@°ï¤H¦W¡A§Æ±æ¥Ñ­«½Æ¦¸¼Æªº¦h¨ì¤Ö¡A¦C¥X­«½Æªº©m¦W¥H¤Î¦¸¼Æ




­ì²z¡G
BÄ滲§UÄ椽¦¡¡GB2=IF(COUNTIF(OFFSET($A$2,,,ROW()-1,),A2)=1,COUNTIF(OFFSET($A$2,,,COUNTA(A:A)-1,),A2)+1/ROW(),)¤U©Ô
COUNTIF(OFFSET($A$2,,,ROW()-1,),A2)¡G¨ì¥Ø«eªº¦C¡A¸Ó©m¦W¥X²{ªº¦¸¼Æ¡A¦pªG¥X²{¶W¹L¨â¦¸ªº¸Ü´N¦^¶Ç¹s
COUNTIF(OFFSET($A$2,,,COUNTA(A:A)-1,),A2)+1/ROW()¡G¦pªG¥u¥X²{¤@¦¸¡A´N¦^¶Ç¸Ó©m¦W¥X²{ªºÁ`¦¸¼Æ¡A«á­±¦A¥[¤@­Ó1/row()¥H¼Ð¥Ü¸Ó©m¦W¥X²{ªº¦C¼Æ

CÄ椽¦¡¡GC2=IFERROR(INDEX(A:A,INT(1%+1/MOD(LARGE(OFFSET($A$2,,1,COUNTA(A:A)-1,),ROW(A1)),1))),"")¤U©Ô
LARGE(OFFSET($A$2,,1,COUNTA(A:A)-1,),ROW(A1))¡G°ÊºA½d³ò¿ï¨ú¾ã­Ó»²§UÄæ¡A¨Ã±N¨ä¼Æ­È¥Ñ¤j¨ì¤p±Æ§Ç
INT(1%+1/MOD(BÄæ¹ïÀ³ªº­È,1))¡G¤W­±¤½¦¡·|±NBÄæ¥Ñ¤j¨ì¤p±Æ§Ç¡A¨Ã¦^¶Ç¨ä­È¡ABÄ檺­È¦³¨â­Ó¸ê°T¡G­«½Æ¦¸¼Æ(¾ã¼Æ³¡¤À)¥H¤Î¦ì¸m(¤p¼Æ³¡¤À)¡A¥Îmod§â¾ã¼Æ³¡¤À§R±¼¡AµM«á¦A¥Î­Ë¼ÆŪ¨ú¨ä¦ì¸m¡C¦]¬°­Ë¼Æ¦A­Ë¼Æ¦³¥i¯à­pºâ¤W·|µy·L¦³¤@ÂI»~®t¡A¦]¦¹«e­±¦A¥[­Ó1%«áµL±ø¥ó±Ë¥h¡A§Y¥iŪ¨úBÄæ¹ïÀ³ªº­È¨ä©Ò¦bªº¦C¼Æ¡C³Ì«á¦A¥Îindex§Y¥iŪ¨ú¨ä©m¦W

DÄ椽¦¡¡GD2=IFERROR(IF(INT(LARGE(OFFSET($A$2,,1,COUNTA(A:A)-1,),ROW(A1)))>0,INT(LARGE(OFFSET($A$2,,1,COUNTA(A:A)-1,),ROW(A1))),""),"")¤U©Ô
INT(LARGE(OFFSET($A$2,,1,COUNTA(A:A)-1,)¡G¸òCÄæ®t¤£¦h¡A¤£¹L¬O¥Îint¨ç¼ÆŪ¨úBÄæ¹ïÀ³ªº­Èªº­«½Æ¦¸¼Æ¡AµM«á¦A¥[¤@¨Ç°ò¥»´«°£¿ù¥\¯à

¾ãÅé¨Ó»¡¥u¥Î¤F¤@­Ó¸É§UÄæ§Y¥i¹F¨ì®ÄªG¡A¦Ó¥B¨S¦³¨Ï¥Î°}¦C¤½¦¡
¤£¹L´N®Ä²v¨Ó»¡¡A·í©m¦W¨ì10000µ§®É®t¤£¦h­n¶]­Ó¤@¤ÀÄÁ¡A¤£ª¾¹D¦³¨S¦³¿ìªk¦A§Ö¤@ÂI¡H

­«½Æ©m¦Wªí.rar (6.67 KB)

ÁÂÁ¤À¨É, ½Ð°Ý¥Î°}¦C¤½¦¡«ç»ò°µ?
ss

TOP

§Úªº°µªk¦n¹³«Ü½ÆÂø, ½Ð«ü±Ð.
testbook.rar (261.96 KB)
ss

TOP

补¤Wscreenshoot
ss

TOP

¦^´_ 1# Bodhidharma

"°Q½×¤£­«½Æ²M³æ", »Ý­n¤j¤jªº«ü¾É
http://forum.twbts.com/viewthrea ... amp;extra=#pid53197
ss

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD