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

[µo°Ý] ·j´M­pºâ«áªº«ü©w¬Û¦P­È¤Î5­Ó¤å¦r¥ô¨ú3­Ó¤å¦rªº¤£­«½Æ²Õ¦X¡C

[µo°Ý] ·j´M­pºâ«áªº«ü©w¬Û¦P­È¤Î5­Ó¤å¦r¥ô¨ú3­Ó¤å¦rªº¤£­«½Æ²Õ¦X¡C

¥ý¯¬ºÖ¦U¦ì¤j¤j¡J
½Þ¦~§Ö¼Ö!¤ß·Q¨Æ¦¨!

¥H¤U3­Ó»Ý¨D¡A
½Ð¦U¦ì¤j¤j¤£§[«ü±Ð!ÁÂÁÂ!
1_Q2¥k©Ô¤U©Ô¤@¦¡¨ì¦ìMS2003ª©ªº¨ç¼Æ¤½¦¡
2_AI2¥k©Ô¤U©Ô¤@¦¡¨ì¦ìMS2003ª©ªº¨ç¼Æ¤½¦¡
3_W1:AF1¥k©Ô¤@¦¡¨ì¦ìMS2003ª©ªº¨ç¼Æ¤½¦¡


½d¨ÒªþÀÉ :
·j´M­pºâ«áªº«ü©w¬Û¦P­È&5¥ô¨ú3ªº¤£­«½Æ²Õ¦X.rar (3.65 KB)

¤£¦n·N«ä¡A»Ý¨D1©M2¦³¤@­Ó³W«h§Ñ¤F»¡©ú~¸É¥R¦p¤U:
·íJ2:N2ªº¬Y¤@­Ó¼Æ­È+1©Î-1±o­È=0®É¡A«hµø±o­È=39
§Y
=IF(MOD(N2+1,39)=0,39,MOD(N2+1,39))
=IF(MOD(N2-1,39)=0,39,MOD(N2-1,39))

¥t¥~:·íJ2:N2ªº¬Y¤@­Ó¼Æ­È+2©Î-2±o­È=0®É¡A«hµø±o­È=39¡F¦p±o­È=-1®É¡A«hµø±o­È=38
§Y
=IF(MOD(N2+2,39)=0,39,MOD(N2+2,39))
=IF(MOD(N2-2,39)=0,39,MOD(N2-2,39))
¨ä¾lK2:N2¦P²zÃþ±À¡C
ÁÂÁÂ!

TOP

¦^´_ 1# papaya


»Ý¨D1_Q2¥k©Ô¤U©Ô¤@¦¡¨ì¦ìMS2003ª©ªº¨ç¼Æ¤½¦¡
=LOOKUP(1,IF({1;0},{0,""},{-1,1}*SMALL(IF(MMULT({1,1,1},1-ISNA(RANK(MOD($D2:$H2+{-1;0;1}-1,39)+1,$J2:$N2))),$D2:$H2),COLUMN(A1))))
°}¦C¤½¦¡

»Ý¨D2_AI2¥k©Ô¤U©Ô¤@¦¡¨ì¦ìMS2003ª©ªº¨ç¼Æ¤½¦¡
=LOOKUP(1,IF({1;0},{0,""},{-1,1}*SMALL(IF(MMULT({1,1,1,1,1},1-ISNA(RANK(MOD($D2:$H2+{-2;-1;0;1;2}-1,39)+1,$J2:$N2))),$D2:$H2),COLUMN(A1))))
°}¦C¤½¦¡

»Ý¨D3_W1:AF1¥k©Ô¤@¦¡¨ì¦ìMS2003ª©ªº¨ç¼Æ¤½¦¡
=LOOKUP(LARGE(IF(LEN(SUBSTITUTE(DEC2BIN(ROW($7:$28),5),0,))=3,ROW($7:$28)),COLUMN(A1)),IF({1,0},ROW($7:$28),IF(MID(DEC2BIN(ROW($7:$28),5),1,1)="1","D","")&IF(MID(DEC2BIN(ROW($7:$28),5),2,1)="1","E","")&IF(MID(DEC2BIN(ROW($7:$28),5),3,1)="1","F","")&IF(MID(DEC2BIN(ROW($7:$28),5),4,1)="1","G","")&IF(MID(DEC2BIN(ROW($7:$28),5),5,1)="1","H","")))
°}¦C¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089
ª©¥D¤j¤j :
·PÁ¦^ÂÐ^^
»Ý¨D1&2->OK¤F!
»Ý¨D3µª®×¬°#NAME?
¥i¯à¬ODEC2BIN->2003ª©¤£¾A¥Î(§Ú­J²qªº)^^"
·Ð½Ð­×¥¿~ÁÂÁ±z!

TOP

¦^´_ 4# papaya


¦pªGµLªk¨Ï¥Î¦¹¨ç¼Æ¡A¥B¶Ç¦^ #NAME? ¿ù»~¡A½Ð°õ¦æµ{¦¡¥H¦w¸Ë¡u¤ÀªR¤u¨ã½c¡v¡C

§@ªk

¦b [¤u¨ã] ¥\¯àªí¤W¡A«ö¤@¤U [¼W¯q¶°]¡C
¦b [²{¦³ªº¼W¯q¶°] ²M³æ¤¤¡A¿ï¨ú [¤ÀªR¤u¨ã½c] ¤è¶ô¡A¦A«ö¤@¤U [½T©w]¡C
¦p¦³»Ý­n¡A¨Ì´`¦w¸Ëµ{¦¡¤Wªº«ü¥Ü°Ê§@¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089
¤£¦n·N«ä¡A"¼W¯q¶°"->"¤ÀªR¤u¨ã½c"->"½T©w"«á~¤½¦¡µª®×¤£ÅÜ¡C
"¤ÀªR¤u¨ã½c"->"ÂsÄý"«á~AddIns¸ê®Æ§¨¬OªÅªº^^"

§ï¦¨³o¼Ë¦n¤F~¥HV1§@»²§UÀx¦s®æ¶ñ¤JDEFGH~
µM«á¦A¶i¦æW1ªº»Ý¨D(3)¤½¦¡¡C
·Ð½Ð¦A«ü¾É!ÁÂÁ±z!

TOP

¦^´_ 6# papaya


    V1§@»²§UÀx¦s®æ¶ñ¤JDEFGH~

¥i¥H¤§«e¤§¤½¦¡¤¤ªº
"D" ¥H MID(V1,1,1)
"E" ¥H MID(V1,2,1)
"F" ¥H MID(V1,3,1)
"G" ¥H MID(V1,4,1)
"H" ¥H MID(V1,5,1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089
¦pªG¦P¼Ë¥H¤§«e¤½¦¡®M¥Î"DEFGH"5­Ó¦r¥À¡A¨º"DEC2BIN"ÁÙ¬OµLªk¾A¥Î^^"
¦pªG¥u¯à¥Î"DEC2BIN"¸ÑÃD¡A¨º´N¥u¦n©ñ±ó¤F~ÁÙ¦n¡A¥u¦³10­Ó²Õ¦X¡A¥Î¤H¤uÁä¤J¤]¨S¦³Ãö«Y^^

ÁÂÁ±zªº­@¤ß«ü¾É!·P®¦b^_^d

TOP

¥HV1§@»²§UÀx¦s®æ¶ñ¤JDEFGH
  1. =IF(MID(LARGE(IF(SUBSTITUTE(TEXT(ROW(111:11100),"00000"),0,)="111",ROW(111:11100)+10^5),COLUMN(A1)),2,1)="1",MID($V1,1,1),"")
  2. &IF(MID(LARGE(IF(SUBSTITUTE(TEXT(ROW(111:11100),"00000"),0,)="111",ROW(111:11100)+10^5),COLUMN(A1)),3,1)="1",MID($V1,2,1),"")
  3. &IF(MID(LARGE(IF(SUBSTITUTE(TEXT(ROW(111:11100),"00000"),0,)="111",ROW(111:11100)+10^5),COLUMN(A1)),4,1)="1",MID($V1,3,1),"")
  4. &IF(MID(LARGE(IF(SUBSTITUTE(TEXT(ROW(111:11100),"00000"),0,)="111",ROW(111:11100)+10^5),COLUMN(A1)),5,1)="1",MID($V1,4,1),"")
  5. &IF(MID(LARGE(IF(SUBSTITUTE(TEXT(ROW(111:11100),"00000"),0,)="111",ROW(111:11100)+10^5),COLUMN(A1)),6,1)="1",MID($V1,5,1),"")
½Æ»s¥N½X
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089

ª©¥D¤j¤j:
ÁÂÁ±zªºµL¨p«ü¾É!µª®×¥¿½T!·P®¦

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD