Simone
例如：6个号号码分别老友锋存在B4:G4数组公式：=COUNT(1/FREQUENCY(ABS(SMALL(B4:G4,ROW(INDIRECT("1:"告山&COUNT(B4:G4))))-TRANSPOSE(SMALL(B4:G4,ROW(INDIRECT("1:"&COUNT(B4:G4)))))),ABS(SMALL(B4:G4,ROW(INDIRECT("1:"&COUNT(B4:G4))))-TRANSPOSE(SMALL(B4:G4,ROW(INDIRECT("1:"&COUNT(B4:G4))))))))-COUNT(B4:G4)，然后按ctrl＋Shift＋Enter组合键锁定数组公式；这时Excel将在公式两边自动加上括号“{}”。侍晌
