以下是引用rujunming在2008-9-25 15:05:00的发言:如何用函数求得3个相同的A中最高分和次高分的两项出来呢?
符合你意否? | | | | | A | 98 | A | | | A | 87 | 最高 | 98 | =LARGE(IF($C$21=$A$21:$A$29,($C$21=$A$21:$A$29)*$B$21:$B$29,0),ROW(1:1)) | b | 79 | 最低 | 55 | =LARGE(IF($C$21=$A$21:$A$29,($C$21=$A$21:$A$29)*$B$21:$B$29,0),SUM(($C$21=$A$21:$A$29)*1)) | c | 85 | | | | d | 66 | | | | E | 86 | | | | A | 55 | | | | b | 56 | | | | x | 76 | | | |
[此贴子已经被作者于2008-9-26 14:33:35编辑过] |