第1个回答 2010-02-01
如资料在SHEET1表.最高购买价在SHEET2,你在SHEET2的C2输入=MAX(IF((Sheet1!$A$2:$A$7="A")*(Sheet1!$B$2:$B$7=$A3)*(Sheet1!$C$2:$C$7=$B3),Sheet1!$D$2:$D$7,""))按SHIFT+CTRL+ENTER结束 再向下填充,D2输入=MAX(IF((Sheet1!$A$2:$A$7="B")*(Sheet1!$B$2:$B$7=$A3)*(Sheet1!$C$2:$C$7=$B3),Sheet1!$D$2:$D$7,""))按SHIFT+CTRL+ENTER结束 再向下填充.
如果就在资料下方求最高购买价,比如在字段在11行,你在C12输入=MAX(IF(($A$2:$A$7="A")*($B$2:$B$7=$A12)*($C$2:$C$7=$B12),$D$2:$D$7,""))按SHIFT+CTRL+ENTER结束 再向下填充.D12输入=MAX(IF(($A$2:$A$7="B")*($B$2:$B$7=$A12)*($C$2:$C$7=$B12),$D$2:$D$7,""))按SHIFT+CTRL+ENTER结束 再向下填充本回答被提问者采纳