本帖最后由 delete_007 于 2015-2-5 08:27 编辑
- =TEXT(LARGE((SUBSTITUTE(MMULT(-TEXT(SUBSTITUTE(A2:F2,ROW(1:10)-1,,1)*11,"0!e-0"),-(MOD(COLUMN(A:BL)/2^ROW(1:6)*2,2)<1))*10^9,0,)&ROW(1:10)-1)*(MMULT(4^(FIND(ROW(1:10)-1,A2:F2&1/17)>2),--(MOD(COLUMN(A:BL)/2^ROW(1:6)*2,2)<1))=3),ROW()-4),"000 0;;")
复制代码 区域数组``- =TEXT(MID(SMALL(-(SUBSTITUTE(TEXT(MMULT(1+TEXT(SUBSTITUTE(A2:F2,{0;1;2;3;4;5;6;7;8;9},,1)*11,"[>99];0!e-0"),--(MOD(COLUMN(A:BL)/2^ROW(1:6)*2,2)<1))*10^9,"[>4e9]!0;[>3e9];"),0,)&ROW(1:10)-1),ROW()-4),3,9),"000 0")
复制代码
补充内容 (2015-2-5 20:50):
=TEXT(LARGE(-(SUBSTITUTE(TEXT((MMULT(1+TEXT(SUBSTITUTE(A2:F2,ROW(1:10)-1,,1)*11,"[>99];0!e-0"),-(MOD(COLUMN(A:BL)/2^ROW(1:6)*2,2)<1))+3)*10^9,"1;[<-1e9]1;0"),0,)&ROW(1:10)-1),ROW()-4),"000 0;")
刚好``
补充内容 (2015-2-5 23:26):
=TEXT(LARGE(-(SUBSTITUTE(TEXT((MMULT(1+TEXT(SUBSTITUTE(A2:F2,ROW(1:10)-1,,1)*11,"[>99];0!e-0"),N(MOD(COLUMN(A:BL)/2^ROW(1:6)*2,2)<1))-3)*10^9,"[>1e9];;-0"),0,)&ROW(1:10)-1),ROW()-4),"000 0;;")
再减1`` |