如何将一列数据中指定的区域,去除重复单元格,显示在另一列?答:=INDEX(OFFSET($B$1,INT((ROW(A1)-1)/10)*100,,100),SMALL(IF(FREQUENCY(OFFSET($B$1,INT((ROW(A1)-1)/10)*100,,100),OFFSET($B$1,INT((ROW(A1)-1)/10)*100,,100))>0,ROW($1:$100)),MOD(ROW(A10),10)+1))or =LET(x,OFFSET($B$1,INT((ROW(A1)-1)/10)*100,...