|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 lolo0514 于 2012-6-24 21:20 编辑
Book2.rar
(6.68 KB, 下载次数: 74)
file:///C:/Documents%20and%20Settings/Administrator/Application%20Data/Tencent/Users/345153151/QQ/WinTemp/RichOle/ELT1TPQ_SHM2G%7D0%60PHP3K]N.jpg 这是我得出的结果
=IF(ROW(1:1)>COUNTIF(A:A,"张三"),"",INDEX(B:B,SMALL(IF(A$2:A$10="张三",ROW($2:$10)),ROW(1:1))))
[img]file:///C:/Documents%20and%20Settings/Administrator/Application%20Data/Tencent/Users/345153151/QQ/WinTemp/RichOle/H5%25P6U_%60JPIS%25Q_[AQIJRXF.jpg[/img] 这是书上得出的结果,可是同样的公式,我检查了十几次也没发现错的,可结果就是不对,麻烦各位高手帮帮忙
|
|