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

[µo°Ý] §ä¥X¦U¸s²Õªº²³¼Æ(¤£§t0)

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-4-4 01:27 ½s¿è
¦^´_  Bodhidharma

©Ò¥H·í¦³¦h­Ó²³¼Æªº®É­Ô¡A§A§Æ±æ¥uÅã¥Ü²Ä¤@­Ó....yes
µM«á¥u¦Ò¼{"³sÄò¥X²{³Ì¦h¦¸". ...
PJChen µoªí©ó 2013-4-4 01:16



"¦pªG¤À¶}¨â­Ó¤£¦P¦a¤è¥X²{¡A´Nµø¬°¤£¦P­È¡H....³o­Ó­Ë¤£¤@©w,À³¸Ó¬O¦P¤@²Õ­Y¦³¤G­Ó¬Û¦Pªº²³¼Æ,¥H³sÄò­Èªº²³¼Æ¬°Àu¥ý¦Ò¶q"
­C¡K§Ú°ÝÃDªº·N«ä¬O»¡
x
x
y
y
y
z
z
z
z
y
y
x
x
x
¬O§_¦bºâ¼Æ¶qªº®É­Ô¡A§Y«Kx¸òyªºÁ`¼Æ¦³5­Ó¡A¦ý¬O¦]¬°¦b¤£¦P¦a¤è¥X²{¡A©Ò¥H³Q¬Ý¦¨"2­Óx,3­Óy,4­Óz,2­Óy',3­Óx'¡A©Ò¥HÁÙ¬O­nÅã¥Ü²Ä¤@­Óz?
µM«á"¥H³sÄò­Èªº²³¼Æ¬°Àu¥ý¦Ò¶q"§Ú¬Ý¤£¤ÓÀ´
³Ì«á¡A§Úªº«e­±¨º­Ó"²³¼Æ_3"ªºÀɮסA¨ì©³²Å¤£²Å¦X§Aªº»Ý¨D°Ú°Ú°Ú¡H

TOP

¦^´_ 31# Bodhidharma

"²³¼Æ_3"ªºÀɮסA¥Ø«e¬Ý¨Ó²Å¦X§Úªº»Ý¨D,¤£¹L§Ú­n¶i¤@¨B®M¶i¥¿±`ªº³øªí¤¤¸Õ¸Õ¬Ý!!

©ú¤Ñ¶}©l³sÄò°²´Á,§Ú­n4ÂI¦h­n°_§É,²{¦b§Ú¤w¸g¸£³UªÅªÅ¤F....­n§ï¤Ñ¤~¯à¸Õ¤F!!§Ú·|¦A¦^Âг̲׵²ªG....

·PÁ§A­Ì¼ö¤ßªºÀ°¦£.....·P¿E¤£ºÉ!!

TOP

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-4-4 01:53 ½s¿è
¦^´_  PJChen

¸Õ¼g¤F¤@­Ó¡A¥[¤F¤@­Ó»²§UÄæ¡A¨ä¹êÅÞ¿è´X¥G¸òHsiehªO¥D¤@¼Ë

©w¸q¦WºÙ¯Âºé¥u¬OÅý¤½¦¡¤£ ...
Bodhidharma µoªí©ó 2013-4-3 23:13


¬ðµMµo²{§Ú¡u©¹¤U¼Æ­È­«½Æ­Ó¼Æ¡v³oÄ榳ÂI°ÝÃD¡A¨C²Õªº³Ì«á¤@­Ó¸ê®Æ¤@©w·|¬OªÅ®æ
D2Àx¦s®æ=IF(($A2=$A3)*($B2>0),IF($B2=$B3,D3+1,1),"")
À³¸Ó­×¥¿¬°
=IF($B2>0,IF((A2=A3)*($B2=$B3),D3+1,1),"")

²³¼Æ_3.rar (9.91 KB)

TOP

1.
²³¼ÆÅý§Ú¥H¬°¬O­n¥Î MODE() ¨ç¼Æ§ä¥X²{ÀW²v³Ì°ªªº¼Æ¡A
À³¸Ó¬O¦U²Õ¤¤§ä¥X³Ì°ª³sÄò­«½Æ¼Æ¤§²Ä¤@¦ì¼Æ¦ì¸m©óCÄæ¼Ð¥Ü¨ä­È¡A¨ä¥L¦ì¸m¼Ð¥Ü¬° 0

2.
´£¨Ñ¤@­Ó¨S¦³¦WºÙ©w¸qªº½d¨Ò¡A¬°¥[³t­pºâ¼W¥[»²§UÄæ±N¨C¤@²Õ³Ì¦h³sÄò­«½Æªº²Ä¤@¼Æ¦ì¸m¼Ð­q¥X¨Ó¡C
=INT(1%+1/MOD(MAX(INDEX(FREQUENCY(-ROW($1:$88),-ROW($1:$88)*(((A$1:A$88<>G2)+(B$1:B$88<>B$2:B$89)+(B$1:B$88=0))>0))+1/ROW($2:$90),)),1))

3.
CÄ檺¤½¦¡´N¯à¤j´T²¤Æ­pºâ
=IF(A2="","",(VLOOKUP(A2,G:H,2,)=ROW())*B2)

4.
½d¦CÀÉ®×
²³¼Æ_ML089.rar (6.71 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ Bodhidharma ©ó 2013-4-7 03:45 ½s¿è
1.
²³¼ÆÅý§Ú¥H¬°¬O­n¥Î MODE() ¨ç¼Æ§ä¥X²{ÀW²v³Ì°ªªº¼Æ¡A
À³¸Ó¬O¦U²Õ¤¤§ä¥X³Ì°ª³sÄò­«½Æ¼Æ¤§²Ä¤@¦ì¼Æ¦ì¸m ...
ML089 µoªí©ó 2013-4-7 01:00


=INT(1%+1/MOD(MAX(INDEX(FREQUENCY(-ROW($1:$88),-ROW($1:$88)*(((A$1:A$88<>G2)+(B$1:B$88<>B$2:B$89)+(B$1:B$88=0))>0))+1/ROW($2:$90),)),1))
³o­Ó¦¡¤l¯u¬O³Õ¤jºë²`¡I
§Q¥Îint(1%+1/mod(max(­«½Æ¦¸¼Æ+1/©Ò¦b¦C¼Æ),1)
¨Ó¦^¶Ç"­«½Æ¦¸¼Æ³Ì¦h¡A¦b³Ì«e­±¥X²{ªº¸ê®Æ¦C¼Æ"³o­Ó¥Îªk«Ü¦³·N«ä
¤§«e¦³¼g¹L¡u­«½Æ¤H¦Wªí¡v¤§ÃþªºªF¦è¡A§Ú¨Ï¥Îªº¤èªk¬O±N­«½Æ¦¸¼Æ*10000+row()¡A(°²³]¸ê®Æ¤p©ó10000µ§)
¨S·Q¨ìÁÙ¦³³oºØ³B²z¤è¦¡¡I

¥t¥~frequency¨ç¼Æªº¥ÎªkÁÙº¡¯S§Oªº
frequency(­t1¨ì­t³Ì«á¤@­Ó¼Æ¦r,­t1¨ì­t³Ì«á¤@­Ó¼Æ¦r¡A¤£¹L¦P²Õ«D¹s¥B»P«e¤@¦C¬Û¦Pªº¸Ü´N¬O0)
¤£¤Ó¤F¸Ñ³oºØ¥Îªk¬°¤°»ò¯à°÷°µ¨ì"²³¼Æ"ªº­n¨D
frequency§Ú¬Ý»¡©ú¤@¯ë¦n¹³¨S¦³³oºØ«D»¼¼Wªºbin_array¥Îªk¡A¤£ª¾¹D­ì²z¬O¤°»ò¡H

§Ú­ì¥»¤]¦³«ä¦Ò¬O§_¯à°÷§¹¥þ¤£¥Î»²§UÄæ¡A¤£¹L·Q¤£¥X¨Ó
³o­Ó¤½¦¡¥i¥H§¹¥þ¹F¨ì§Ú»²§UÄæ¡u©¹¤U¼Æ­È­«½Æ­Ó¼Æ¡vªº®ÄªG¡I
(¤£¹L¦b¤½¦¡®Ä²v¤W¦]¬°¦³¥Î¨ì°}¦C¬Û­¼¡AÀ³¸Ó·|²¤»¹©ó¥Î»²§UÄ檺¤è¦¡)

¥t¥~§Ú¤]¦³«ä¦Ò¬O§_¯à¼W¥[²Õ¦W»P"²³¼Æ"ªº¹ï·ÓÄæ
¤£¹L¦]¬°­ìpoªº¸ê®Æ·|¤@ª½¼W¥[¡A©Ò¥H«ÜÃø¥Î°ÊºAªº¤è¦¡³]©w»²§UÄæ
¦]¦¹«á¨Ó§Ú´N©ñ±ó¤F¡AÁÙ¬O¦^¨ìoffsetªº¤è¦¡¨Ó³B²z

TOP

¥t¥~§Ú¤]¦³«ä¦Ò¬O§_¯à¼W¥[²Õ¦W»P"²³¼Æ"ªº¹ï·ÓÄæ
¤£¹L¦]¬°­ìpoªº¸ê®Æ·|¤@ª½¼W¥[¡A©Ò¥H«ÜÃø¥Î°ÊºAªº¤è¦¡³]©w»²§UÄæ
¦]¦¹«á¨Ó§Ú´N©ñ±ó¤F¡AÁÙ¬O¦^¨ìoffsetªº¤è¦¡¨Ó³B²z
Bodhidharma µoªí©ó 2013-4-7 03:43


¨ä¹ê¤]ÁÙ¦n¡A¥Î
{=IFERROR(INDEX(A:A,SMALL(IF(OFFSET($A$2,,,COUNTA(A:A),)=OFFSET($A$3,,,COUNTA(A:A),),"",ROW(OFFSET($A$2,,,COUNTA(A:A),))),ROW(A1))),"")}
¤§Ãþªº¤½¦¡´N¥i¥H§ì¥X©Ò¦³ªº²Õ¦W
µM«á²³¼Æ¦ì¸m¨ºÄæ¦A§Ë­Ó°ÊºA½d³ò°ò¥»¤W´N²Å¦X­ìpoªº»Ý¨D¤F

TOP

¦^´_ 36# Bodhidharma
1.³o¼Ë¥i¶Ç¦^¦P¸s²Õ¤ºBÄæ¦U¼Æ­Èªº²Ä¤@¦¸¥X²{ªº¦ì¸m¡A¶Ç¦^¸Ó¼Æ­È¥X²{¦¸¼Æ  
=FREQUENCY(OFFSET($B$1,MATCH($A2,$A:$A,0)-1,,COUNTIF($A:$A,$A2),)*10^0,OFFSET($B$1,MATCH($A2,$A:$A,0)-1,,COUNTIF($A:$A,$A2),)*10^0)
2.³o¼Ë§PÂ_¬O§_BÄæ¼Æ­È¬°³sÄò¥X²{
=(FREQUENCY(INDIRECT("RC2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0,INDIRECT("RC2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0)=FREQUENCY(INDIRECT("R[1]C2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0,INDIRECT("R[1]C2:R"&MATCH($A2,$A:$A,0)+COUNTIF($A:$A,$A2)-1&"C2",0)*10^0)+1)
3.CÄæ¥u­n¬O¥H¤W¨â±ø¥ó§k¦X´N¬O¸Ó¸s²Õ³sÄò³Ì¦hªº²³¼Æ
¨â­Ó§PÂ_¦¡¬Û­¼¦A­¼¤WBÄ檺­È¡A´N¯à±o¨ìµª®×
²³¼Æ.rar (12.04 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 36# Bodhidharma

¤½¦¡³t«×­n§Ö¡A»Ý­n±N¨C¤@¶µ³£·| ­«½Æ­pºâªº­pºâ¼Æ Åý·Q¿ìªk¥u­pºâ¤@¦¸¡A´N»Ý­n¥Î »²§UÄæ ©Î ©w¸q¦WºÙ¡C

§Ú´£¨Ñªº »²§UÄæ ¤½¦¡¬O±Ä¥Î ÂX¤j½d³ò ¨Ó­pºâ¡A¦pªG ²Õ¶µ «D±`¦h®É¥i¥H±Ä¥Î °ÊºA½d³ò ¨Ó´À¥N¡A¥i¥HÁYµu§ó¦h®É¶¡¡C

©w¸q¦WºÙ ¨ä¹ê¤]¥i¥H¥[§Ö­pºâ¡A¨Ã«D¨Ï¥Î ©w¸q¦WºÙ ´N·|ÅܺC¡A¨Ò¦p¤@­Ó¤½¦¡¤º·|¨Ï¥Î¦n´X¦¸ °ÊºA½d³ò¡A¥Î ©w¸q¦WºÙ ¨Ó³] °ÊºA½d³ò ´N¯à¸`¬Ù¤£¤Ö®É¶¡¡C
­Y ©w¸q¦WºÙ ¬Û¹ï©ó¨C¤@­ÓÀx¦s®æ³£¬O "¤Þ¼Æ" ³£»Ý­n®Ú¾Ú³o¨Ç "¤Þ¼Æs"¦¹°µ¤@¹M­pºâ¡A³o®É¤Ï¦Ó·|Åܱo§óºC¡C

¥xºÝ¤W­±ªº¤ÀªR»¡©ú¼gªº«Ü´Î¡AÀ³¸Óµ¹§A¤@­ÓÆg¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦¹ÃD±Ä¥Î««ª½»²§UÄæ ¥i¥H¥Î¤U¦C¤½¦¡¸û¬°Â²³æ

²Ä¤@­Ó³Ì°ª¦¸¼Æªº­È
D2 =IF(ROW()=INT(1%+1/MOD(MAX(OFFSET(E$1,MATCH(A2,A:A,)-1,,COUNTIF(A:A,A2))),1)),B2,"")

»²§UÄæ : ¬O§_³sÄò¥X²{¡A®æ¦¡³]¬°¾ã¼Æ«¬ºA¸û¬°¬üÆ[
E2 =IF(B2=B3,INT(N(E3))+1+1/ROW(),"")

²³¼Æ0407.rar (23.43 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦¹ÃD±Ä¥Î««ª½»²§UÄæ ¥i¥H¥Î¤U¦C¤½¦¡¸û¬°Â²³æ

²Ä¤@­Ó³Ì°ª¦¸¼Æªº­È
D2 =IF(ROW()=INT(1%+1/MOD(MAX(OFFSE ...
ML089 µoªí©ó 2013-4-7 11:03


¶â¡A¤@¼Ë©l¥Î int(1%+1/mod(max(­«½Æ¦¸¼Æ+1/©Ò¦b¦C¼Æ),1) ªº­ì²z
«O¯d¤F"­«½Æ¦¸¼Æ"¥H¤Î"¸Ó¦C¦b¾ã­Ó¤u§@ªíªº²Ä´X­Ó¦ì¸m"ªº¸ê°T
¦]¦¹¦b¹ïÀ³ªº®É­Ô¡A´N¤£¥Î¹³§Úªº¤è¦¡offset¥b¤Ñ¡A§ä¡u¸Ó¦C¦b¸Ó²Õªº²Ä´X­Ó¦ì¸m¡v¡A¥i¥Hª½±µ¹ïÀ³¡u¸Ó¦C¦b¾ã­Ó¤u§@ªíªº²Ä´X­Ó¦ì¸m¡v

¤£¹LE2¤½¦¡
=IF(B2=B3,INT(N(E3))+1+1/ROW(),"")
¨Ã¨S¦³³B²z"¤£¦P²Õ"©Î¬O"¼Æ­È¬°¹s"ªº±¡ªp¡A¬O§_À³§ï¬°
=IF(B2>0,IF((A2=A3)*(B2=B3),INT(N(E3))+1+1/ROW(),1+1/ROW()),"") ?

¥t¥~frequency¨ç¼Æ§Ú¤£¬O«Ü¼ô
¥i§_¸ÑÄÀ¤@¤U¡A·íbin_array«D»¼¼W®É­Ô¸Ó¨ç¼Æªº¹Bºâ¹Lµ{¡H

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD