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

¨ú((¬YÀx¦s®æ©T©w+8­Ó¼Æ­È)/39)ªº¾l¼Æ¡A·í¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C

¨ú((¬YÀx¦s®æ©T©w+8­Ó¼Æ­È)/39)ªº¾l¼Æ¡A·í¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C



±ND2©T©w+1,2,3,5,8,13,21,34µ¥8­Ó©M­È¡A¦U/39ªº¾l¼ÆÅã¥Ü¦bCL2¡JCS2¡A¦pªG¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C
±NE2©T©w+1,2,3,5,8,13,21,34µ¥8­Ó©M­È¡A¦U/39ªº¾l¼ÆÅã¥Ü¦bCU2¡JDB2¡A¦pªG¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C
±NF2©T©w+1,2,3,5,8,13,21,34µ¥8­Ó©M­È¡A¦U/39ªº¾l¼ÆÅã¥Ü¦bDD2¡JDK2¡A¦pªG¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C
±NG2©T©w+1,2,3,5,8,13,21,34µ¥8­Ó©M­È¡A¦U/39ªº¾l¼ÆÅã¥Ü¦bDM2¡JDT2¡A¦pªG¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C
±NH2©T©w+1,2,3,5,8,13,21,34µ¥8­Ó©M­È¡A¦U/39ªº¾l¼ÆÅã¥Ü¦bDV2¡JEC2¡A¦pªG¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C

½Ð°Ý¡J
CL2¥k©Ô¤U©Ô¤@¦¡¨ì¦ì(©ÎCL2,CU2,DD2,DM2,DV2µ¥5¬q)ªº2003ª©¨ç¼Æ¤½¦¡?
ÁÂÁÂ!

½d¨ÒªþÀÉ¡J
³æÀx¦s®æ©T©w+8­Ó¼Æ­È.rar (162.57 KB)

N1:
=MOD($D2+INDEX({1,2,3,5,8,13,21,34},COLUMN(A$1))-1,39)+1
N2~N5­×§ï¬õ¦â¦ì¸m

©Î:
=IF(MOD(COLUMN(A1),9),MOD(INDEX(2:2,INT(COLUMN(I$1)/9)+3)+INDEX({1,2,3,5,8,13,21,34},MOD(COLUMN(A1),9))-1,39)+1,"")
¥k©Ô/¤U©Ô

TOP

¦^´_ 2# ­ã´£³¡ªL

­ã´£ª©¤j:
´ú¸Õ¦¨¥\^^
ÁÂÁ±zªº«ü¾É!·P®¦

TOP

¦^´_ 2# ­ã´£³¡ªL

ª©¥D¤j¤j:
¤£¦n·N«ä¡A·Q±NSheet1ªºBT3¤½¦¡(§Y2#ªº¸Ñµª¤½¦¡)¨Ö¤JDM3¤½¦¡¡A¥H´Á¯à¬Ù²¤45Äæ¡C
»Ý¨D»¡©ú¸Ô¦pSheet2

¤£ª¾¯à§_¦A·Ð½Ð±z«ü¾É!ÁÂÁ±z!
½d¨ÒªþÀÉ:
¦X¨Ö¤½¦¡.rar (163.44 KB)

TOP

BT2/°}¦C¤½¦¡:
=IF(MAX(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1)=MAX($BS2:BS2),"",SMALL(IF(FREQUENCY(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1,ROW($1:$39)),ROW($1:$39),99),COLUMN(A$1)))

©Î:
=TEXT(SMALL(IF(FREQUENCY(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1,ROW($1:$39)),ROW($1:$39),99),COLUMN(A$1)),"[<40]0;;;")

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2019-2-13 16:21 ½s¿è

¦^´_ 5# ­ã´£³¡ªL
ª©¥D¤j¤j:
2­Ó¤½¦¡³£¬O¥¿¸Ñ~·PÁ±zªº¦^ÂЩM¸Ñµª¡C

½Ð±Ð¤@¤U:
¤½¦¡1
=IF(MAX(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1)=MAX($BS2:BS2),"",SMALL(IF(FREQUENCY(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1,ROW($1:$39)),ROW($1:$39),99),COLUMN(A$1)))
¦]¬°¤½¦¡"¤@©w­n"©Ô¨ì39®æ¡A ¤~ª¾³Ì«áµ²ªG¡A©Ò¥H·í¨ú1ªº¼Æ­È­Ó¼Æ<=39­Ó¡A¨ä¾l«á­±ªºªÅ®æ·|Åã¥Ü99

¦³¸Õ±N99®M§ï¬°¤½¦¡2ªº"[<40]0;;;"¡C¦ý­Ó¼Æ<=39­Óªº¦h¾l«á­±ªºªÅ®æ·|Åã¥Ü#NUM!¡A¤£¬O"ªÅ¥Õ"^^"

¥Ø«e¬O±Ä¥Î¤½¦¡2¡A¦ýı±o¤½¦¡1¤]«D±`´Î¡A­È±o¬ã²ß¡A©Ò¥H¦A¦¸¥´ÂZ©M½Ð±Ð¡A·q½Ð¨£½Ì!ÁÂÁ±z!

TOP

¦^´_ 6# papaya


¤½¦¡1, ©Ô¨ì³Ì«á¤£·|¥X²{99ªº~~

TOP

¦^´_ 7# ­ã´£³¡ªL
§Ú´ú¸Õ¬O·|~¦b39®æªº½d³ò¤ºªº39¸¹¼Æ­È¤§«á·|Åã¥Ü99(¦p#6ªº¹Ï¤ù)¡C
¨SÃö«Y¡A¦³¤½¦¡2´N«Ü¦n¤F¡C
ÁÂÁ±z

TOP

¦^´_ 8# papaya

¬Ýªþ¥ó:
¦X¨Ö¤½¦¡v01.rar (183.18 KB)

¤½¦¡2©Ò±oªº¼Æ¦r¬O"¤å¦r®æ¦¡", ¥i¯àµLªk°µ¨ä¥¦¹Bºâ,
¤½¦¡1¬O"¼Æ­È®æ¦¡"

TOP

¦^´_ 9# ­ã´£³¡ªL
ª©¥D¤j¤j:
§ì¥Xbug¤F
=IF(MAX(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1)=MAX($BS2:BS2),"",SMALL(IF(FREQUENCY(MOD($D2:$H2+{1;2;3;5;8;13;21;34}-1,39)+1,ROW($1:$39)),ROW($1:$39),99),COLUMN(A$1)))
¦]¬°¤ñ¹ï­n®t1¦C(BT3­n¤ñ¹ï$D2:$H2ªº5­Ó¼Æ¦r+{1;2;3;5;8;13;21;34}¡A
©Ò¥H¥u­n§â$BS2:BS2§ï¬°$BS3:BS3¡A¤½¦¡ªºµª®×­È´N¥þ¹ï¤F!
¦]¦¹¤£¬O¤½¦¡¤£¹ï¡A¬O§Ú¾ÇÃÀ¤£ºë^^"

·PÁ±zªº­@¤ß«ü¾É¡AÅý§Ú¾Ç²ß¨ì³\¦h¡A·P®¦b^_^d

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD