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

­Y¦¸¤j­Èªº­Ó¼Æ¤j©ó1­Ó¥H¤W®É¸Ó¦p¦ó³]©w¤½¦¡

­Y¦¸¤j­Èªº­Ó¼Æ¤j©ó1­Ó¥H¤W®É¸Ó¦p¦ó³]©w¤½¦¡

TEST.rar (7.74 KB) ·Ð½Ð¦U¦ì«e½ú¸Ñ´b¡AÃD¥Ø¤Î°ÝÃD©óªþ¥[Àɮפº¡AÁÂÁÂ

¤å¦r´y­z¤£¦p±N¸Ñµª½d¥»¡A³o¼Ë°t¦X§Aªº»¡©ú¤~¯à§Ö³t²z¸Ñ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
TEST1.zip (9.21 KB)
1.­º¥ý·PÁÂML089¤j¤j±zªº¦^ÂФΫü±Ð¡C
2.°w¹ïML089¤j¤jªº«ü±Ð¤©¥H­×¥¿»¡©ú¡G
¦pªþ¥ó1ªºµª®×¦p­Y2013/10/1¥i±o¨ì»Ý¨D¡A
¦ý­Y¬O¦p2013/10/2®É¦¸¤j­Èªº­Ó¼Æ¤j©ó1­Ó
¥H¤W®É±NµLªk±o¨ì»Ý¨D¡A¦]¬°¥H¥Ø«e§Úªº¤½¦¡
·|¨Ï±o¨C­Ó¦¸¤j­È¬Ò·|¥h¦©´î¬Y­È¡A§Úªº»Ý¨D¬O
±q¥ô¤@¦¸¤j­ÈÀx¦s®æ¦©°£¬Y­È¡C¦p¦¹»¡©ú¤£ª¾¬O§_
¦³§ïµ½ML089¤j¤j©Ò´£ªº¯Ê¥¢¡C
3.¦]¬°¦Û¤vªº¾|²õ¦Ó³y¦¨µo«H¦b¤£¹ïªº°Ï°ì¡A­Y¬Oª©¥D
¦P·N¬O§_¥i±N¥»¥DÃD²¾¦Ü¤@¯ë°Ï¡A¦b¦¹¬°¦Û¤v¤£·VªººA«×
­Pºp¡C(­ì·Q¦b¤@¯ë°Ï­«µo¥DÃD¡A¦ý¦p¦¹°µ¦³Äé¤ô¤§ºÃ¡A©Ò¥H©ñ±ó¦¹·Qªk)

TOP

¦^´_ 3# sptakung1


¤p§Ì¤£¬O«Ü¼F®`¡A¤£¤ÓÀ´°}¦C¡A¥u·|³o¼Ë§ï¡A§A¬Ý¬Ý³o¼Ë¥i¥H¶Ü¡H

TEST.rar (8.55 KB)

TOP

¦^´_ 3# sptakung1


¶¶«K¸ò§A»¡¤@¤U¤½¦¡¨ç·N¡A
¦]¬°§A¬O­nºâ¤H¸£§PÂ_ªº²Ä¤G¤j­È¡A§A¥i¥H¥Î¸£³U»´ÃP§PÂ_¥X¦P®É¦n¦h­Ó³Ì¤j­È¤§¥~ªº²Ä¤G¤j­È¡A
¥i¬O¹q¸£¦b¦P®É¦³¦n´X­Ó³Ì¤j­Èªº®É­Ô(°²³]¦³¤»­Ó8)¡A¥Lªº²Ä¤@~¤»¤j­È¡A³£¬O§PÂ_¬°8¡Aª½¨ì²Ä¤C¤j­È¡A¤~·|¬O¹ê»Ú¤W§Ú­Ì¤H¸£»{©wªº²Ä¤G¤j­È¡C
¦]¦¹§Ú­Ì´N¥i¥H¥ýºâ¥X¦@¦³´X­Ó³Ì¤j­È¡G=COUNTIF(octor2,MAX(octor2))      µª®×¬°6
©Ò¥H§Ú­Ì¤F¸Ñ¨ì¦boctor2½d³ò¸Ì¡A§Ú­Ì©Ò­nªº²Ä¤G¤j­È¡A¨ä¹ê¦b¹q¸£ªº§PÂ_¸Ì¹ê»Ú¬O²Ä¤C¤j­È¡C
¨º§Ú­Ì´N¥i¥H¹B¥Î§Þ¥©³]©w¥X§Ú­Ì¹ê»Ú¤W©Ò­nªº²Ä¤G¤j­È¡G=LARGE(octor2,COUNTIF(octor2,MAX(octor2))+1)   
¥H¤W¡A§Æ±æ¹ï§A¦³À°§U¡C

TOP

¦^´_ 3# sptakung1


R3:AC4 ½d³ò°}¦C¤½¦¡
=B3:M4-IF(MOD(LARGE(B3:M4*10^9+ROW(B3:M4)*1000+COLUMN(B3:M4),2),10^9)=ROW(B3:M4)*1000+COLUMN(B3:M4),N4,0)

¥ý¿ï¾Ü R3:AC4 ½d³ò
¿é¤J¤½¦¡¥H CTRL+SHIFT+ENTER ¤TÁä»ô«ö¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤Ñ§r¡A§Ú±qÀY¨ì§À³£·d¿ù¤F­ìPOªº·N«ä¤F¡A¯u¬O¤£¦n·N«ä@@

TOP

¦^´_ 7# owen06

owen06¤j¤j¡GÁÂÁ±zºë±mªº¸Ñ»¡¡A¦]¬°§Úªº»y¤åªí¹F¯à¤O¤Ó®t¡A³y¦¨±z»~¸ÑÃD·N¡A¬Æ·P©êºp¡A¦A¦¸·PÁ±zªº¼ö±¡µªÂСC

TOP

¦^´_ 6# ML089

ML089¤j¤j±z¦n¡G±zªºµª®×§¹¥þº¡¨¬§Úªº»Ý¨D¡AÁÂÁ±z¡C¤£¹L¦¹µª®×ªºÅÞ¿èÁÙ¯u°÷§ÚÁ@ªº¡A¦b¦¹¥ý¦¬¤U¦AºCºC¬ã¨s¤F¡C
¦A¦¸·PÁ±z¡C

TOP

¦^´_ 9# sptakung1

³o¬O­É¸¡¥Í¤lªº§Þ¥©
B3:M4*10^9+ROW(B3:M4)*1000+COLUMN(B3:M4) ±N­ìÀx¦s®æ¼Æ­È»P¸ÓÀx¦s®æ ROW()¡BCOLUMN()ªº¦ì¸m«Ê¸Ë¬°¤@­Ó¼Æ­È¦A¥Î LARGE()¨ú¥X²Ä¤G¤j¼Æ­È¡A
¥Î LARGE()¨ú¥X²Ä¤G¤j¼Æ­È«á¡A¦A¥ÎMOD()¨ç¼Æ±N¥h±¼­ìÀx¦s®æ¼Æ­È(«e­±¤½¦¡¦³¨Ç¤p¿ù»~­n­×¥¿¡A¸Ô«á)¡A¶i¦æROW»PCOLUMN¦ì¸mªº¤ñ¹ï¡A¦¨¥\¦ì¸m´N»Ý­n´î±¼N4¤§­È¡C


¤½¦¡­×¥¿¦p¤U(±NMOD(... , 10^9)§ï¬°MOD( ... , 10^6)
=B3:M4-IF(MOD(LARGE(B3:M4*10^9+ROW(B3:M4)*1000+COLUMN(B3:M4),2),10^6)=ROW(B3:M4)*1000+COLUMN(B3:M4),N4,0)

¤½¦¡­­¨î1 :Àx¦s®æ½d³ò ROW()¡BCOLUMN() <= 999
¤½¦¡­­¨î2 :Àx¦s®æ¼Æ­È¤p¼Æ¦ì <= 3
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD