|
本帖最后由 lisachen 于 2012-4-7 17:36 编辑
lwlw 发表于 2012-4-7 17:25
唉!文盲真可怕,我这一句,我改了半天,感谢解决,我还有一个引用函数怎么结果是错的,你再帮我看看,我 ...
- =IF(ROW()<=ROUND(SUM(1/COUNTIF(Sheet1!$B$2:$B$14,Sheet1!$B$2:$B$14)),0),INDEX(Sheet1!$B$2:$B$14,SMALL(IF(MATCH(Sheet1!$B$2:$B$14,Sheet1!$B$2:$B$14,0)=ROW(Sheet1!$B$1:$B$13),ROW(Sheet1!$B$2:$B$14)),ROW())),"")
复制代码 =IF(ROW()<=ROUND(SUM(1/COUNTIF(Sheet1!$B$2:$B$14,Sheet1!$B$2:$B$14)),0),INDEX(Sheet1!$B$2:$B$14,SMALL(IF(MATCH(Sheet1!$B$2:$B$14,Sheet1!$B$2:$B$14,0)=ROW(Sheet1!$B$1:$B$13),ROW(Sheet1!$B$2:$B$14)),ROW())),"")
没简化
|
|