T
tkt_tang
Re : Excel - Maximum of a Range Row-by-Row
1. Enter an Excel Worksheet Range say, A1:E10, complete with a unique
number in each cell.
2. Would like to return the Maximum number of each Row in the given
Range.
3. That means, each Row (consisting of 5 cells) is evaluated in turn.
4. That means, 10 Maximum numbers will be returned in an array (since
there are 10 Rows in the Range).
5. The requirement is, to devise an Array Formula (one and only one,
entered into cell F1) in order to return an Array of the 10 Maximum
numbers. Alternatively, be that a Named Formula will befit too.
6. Please share your comments.
7. Regards
1. Enter an Excel Worksheet Range say, A1:E10, complete with a unique
number in each cell.
2. Would like to return the Maximum number of each Row in the given
Range.
3. That means, each Row (consisting of 5 cells) is evaluated in turn.
4. That means, 10 Maximum numbers will be returned in an array (since
there are 10 Rows in the Range).
5. The requirement is, to devise an Array Formula (one and only one,
entered into cell F1) in order to return an Array of the 10 Maximum
numbers. Alternatively, be that a Named Formula will befit too.
6. Please share your comments.
7. Regards