[已解决]如何用公式求满足条件一和条件二时，对应的值?（有两个值C100和C200)

baksy

C15=INDEX(C$1:C$7,SMALL(IF((A$2:A$7=A$15)*(B$2:B$7=B$15),ROW(A$2:A$7)),ROW(A1)))
三键回车，下拉。

tgydslr

fengfgc 发表于 2014-5-28 19:11
可以两个单元显示

1. =INDIRECT("c"&SMALL(IF((A$2:A$7=A$15)*(B$2:B$7=B$15),ROW($2:$7)),ROW(A1)))

复制代码

C15输入，三键下拉

tgydslr

显示在一个单元格

1. =TEXT(SUM(SMALL(IF((A2:A7=A15)*(B2:B7=B15),--RIGHT(C2:C7,3)),ROW(INDIRECT("1:"&COUNT(1/((A2:A7=A15)*(B2:B7=B15))))))*1000^(COUNT(1/((A2:A7=A15)*(B2:B7=B15)))-ROW(INDIRECT("1:"&COUNT(1/((A2:A7=A15)*(B2:B7=B15))))))),REPT("C000 ",COUNT(1/((A2:A7=A15)*(B2:B7=B15)))))

复制代码

fengfgc

baksy 发表于 2014-5-28 19:21
C15=INDEX(C$1:C$7,SMALL(IF((A$2:A$7=A$15)*(B$2:B$7=B$15),ROW(A$2:A$7)),ROW(A1)))
三键回车，下拉。

谢谢