¨ú((¬YÀx¦s®æ©T©w+8Ó¼ÆÈ)/39)ªº¾l¼Æ¡A·í¾l¼Æ=0®É¡A«h¥H39Åã¥Ü¡C
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¨ú((¬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)
|
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
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©Ô |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 2# ã´£³¡ªL
ã´£ª©¤j:
´ú¸Õ¦¨¥\^^
ÁÂÁ±zªº«ü¾É!·P®¦ |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 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)
|
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
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;;;") |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¥»©«³Ì«á¥Ñ 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)))
¦]¬°¤½¦¡"¤@©wn"©Ô¨ì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!
|
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 6# papaya
¤½¦¡1, ©Ô¨ì³Ì«á¤£·|¥X²{99ªº~~ |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 7# ã´£³¡ªL
§Ú´ú¸Õ¬O·|~¦b39®æªº½d³ò¤ºªº39¸¹¼ÆȤ§«á·|Åã¥Ü99(¦p#6ªº¹Ï¤ù)¡C
¨SÃö«Y¡A¦³¤½¦¡2´N«Ü¦n¤F¡C
ÁÂÁ±z |
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 8# papaya
¬Ýªþ¥ó:
¦X¨Ö¤½¦¡v01.rar (183.18 KB)
¤½¦¡2©Ò±oªº¼Æ¦r¬O"¤å¦r®æ¦¡", ¥i¯àµLªk°µ¨ä¥¦¹Bºâ,
¤½¦¡1¬O"¼ÆȮ榡" |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 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(BT3n¤ñ¹ï$D2:$H2ªº5ӼƦr+{1;2;3;5;8;13;21;34}¡A
©Ò¥H¥un§â$BS2:BS2§ï¬°$BS3:BS3¡A¤½¦¡ªºµª®×È´N¥þ¹ï¤F!
¦]¦¹¤£¬O¤½¦¡¤£¹ï¡A¬O§Ú¾ÇÃÀ¤£ºë^^"
·PÁ±zªº@¤ß«ü¾É¡AÅý§Ú¾Ç²ß¨ì³\¦h¡A·P®¦b^_^d |
|
|
|
|
|
|