|
发表于 2012-2-29 18:56
|
显示全部楼层
本楼为最佳答案
本帖最后由 5blessyou 于 2012-2-29 18:59 编辑
B2- =INDEX(Sheet1!$2:$2,SUMPRODUCT((Sheet1!B$2:DI$341=A2)*COLUMN(B:DI))/COUNTIF(Sheet1!B$2:DI$341,A2))
复制代码
或者数组公式
- =INDEX(Sheet1!$2:$2,MIN(IF(Sheet1!B$2:DI$341=A2,COLUMN(B:DI),4^4)))
复制代码 或者
- =INDEX(Sheet1!$2:$2,MAX((Sheet1!B$2:DI$341=A2)*COLUMN(B:DI)))
复制代码
|
|