C1输入=IF(COUNTIF(A$1:A1,A1)=1,AVERAGE(IF(A$1:A$100=A1,B$1:B$100)),””)数组公式,输入后先不要回车,按Ctrl+Shift+Enter结束计算,再向下填充。
This entry was posted on March 31, 2014 at 8:56 am and is filed under Excel. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Leave a Reply