Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel - Maximum of a Range Row-by-Row
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum value within a time range | Excel Worksheet Functions | |||
look up maximum date in a range | Excel Discussion (Misc queries) | |||
maximum over a non continuous range | Excel Worksheet Functions | |||
maximum number from a text range | Excel Worksheet Functions | |||
Maximum Range size? | Excel Programming |