Excel查找最近出现的5个不重复数字怎么写公式答:=IF(J1=0,"0","")&SUM(LOOKUP(SMALL(IF(MATCH(N(OFFSET(A1,,10-COLUMN(A:J))),N(OFFSET(A1,,10-COLUMN(A:J))),)=COLUMN(A:J),COLUMN(A:J)),{1,2,3,4,5}),IF(MATCH(N(OFFSET(A1,,10-COLUMN(A:J))),N(OFFSET(A1,,10-COLUMN(A:J))),)=COLUMN(A:J),COLUMN(A:J...