ML089

¦^´_ 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¤½¦¡

ML089

¦^´_ 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

ML089

¦^´_ 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)

ML089

¥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