EXCEL 中 如图 三列数据对比
发布网友
发布时间：2022-04-21 02:29
共1个回答
热心网友
时间：2022-06-17 08:46
=IF(COUNTIFS(A2:C2,"<="&MEDIAN(A2:C2)*1.1,A2:C2,">="&MEDIAN(A2:C2)*0.9)>1,AVERAGEIFS(A2:C2,A2:C2,">="&MEDIAN(A2:C2)*0.9,A2:C2,"<="&MEDIAN(A2:C2)*1.1),"X")
下拉
