=SUMPRODUCT(MAX(($A$1:$A$12=E3)*($B$1:$B$12=F3)*($C$1:$C$12)))
{=INDEX($C$1:$C$12,MATCH(1,($A$1:$A$12=E3)*($B$1:$B$12=F3)*($C$1:$C$12=MAX(IF(($A$1:$A$12=E3)*($B$1:$B$12=F3),$C$1:$C$12,""))),0))}
{=INDIRECT("C"&MATCH(1,($A$1:$A$12=E3)*($B$1:$B$12=F3)*($C$1:$C$12=MAX(IF(($A$1:$A$12=E3)*($B$1:$B$12=F3),$C$1:$C$12,""))),0))}
'엑셀 (Excel) 활용' 카테고리의 다른 글
| quotient, mod, text, time (0) | 2022.05.30 |
|---|---|
| 중간값 이상 평균 : average, if, averageif, median (0) | 2022.05.30 |
| vlookup, indirect, 이름정의 (0) | 2022.05.30 |
| 최초값, 최근값 : index, match, true, isnumber, small, column, row, address, max, if, sum, 배열식 (0) | 2022.05.30 |
| 문자분리 : char(32), left, right, len, find (0) | 2022.05.30 |