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 |
All times are GMT +1. The time now is 08:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com