本帖最后由 hcm19522 于 2019-1-20 15:17 编辑
D6:E16=REPLACE(IF(COLUMN(A1)=1,"*****",C6),5-RIGHT(LARGE(MMULT({1,1,1,1,1},ISNUMBER(-MID($C1:$C5,{1,2,3,4,5},1))*1)/1%+(5-{1,2,3,4,5}),COLUMN(A1)),2),1,MID($B6,5-RIGHT(LARGE(MMULT({1,1,1,1,1},ISNUMBER(-MID($C1:$C5,{1,2,3,4,5},1))*1)/1%+(5-{1,2,3,4,5}),COLUMN(A1)),2),1))
方式二F6:F16=REPLACE(REPLACE("*****",5-RIGHT(LARGE(MMULT({1,1,1,1,1},ISNUMBER(-MID(C1:C5,{1,2,3,4,5},1))*1)/1%+(5-{1,2,3,4,5}),1),2),1,MID(B6,5-RIGHT(LARGE(MMULT({1,1,1,1,1},ISNUMBER(-MID(C1:C5,{1,2,3,4,5},1))*1)/1%+(5-{1,2,3,4,5}),1),2),1)),5-RIGHT(LARGE(MMULT({1,1,1,1,1},ISNUMBER(-MID(C1:C5,{1,2,3,4,5},1))*1)/1%+(5-{1,2,3,4,5}),2),2),1,MID(B6,5-RIGHT(LARGE(MMULT({1,1,1,1,1},ISNUMBER(-MID(C1:C5,{1,2,3,4,5},1))*1)/1%+(5-{1,2,3,4,5}),2),2),1)) |