Dimitris254
Board Regular
- Joined
- Apr 25, 2016
- Messages
- 139
i'm scanning some ranges with an array to get the max value:
but i don't want the max, i want to get the row where this max is.
however, if i put CELL or ROW, Excel doesn't accept it
is not possible at all?
Code:
{=MAX(IF(A2:A12=J7; IF(B2:B12=L5 ;D2:D12)))}
but i don't want the max, i want to get the row where this max is.
however, if i put CELL or ROW, Excel doesn't accept it
is not possible at all?