¥»©«³Ì«á¥Ñ 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¤£¦hn¶]Ó¤@¤ÀÄÁ¡A¤£ª¾¹D¦³¨S¦³¿ìªk¦A§Ö¤@ÂI¡H
«½Æ©m¦Wªí.rar (6.67 KB)
|