| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to find the row number of the maximum value in a coll
Thanks.
"Ron Rosenfeld" wrote: On Fri, 19 Jan 2007 12:42:00 -0800, josht wrote: I need a spreadsheet function that will tell me in what row is the maximum number in the collumn. Function returns the row number in which the maximum value is. =MATCH(MAX(A:A),A:A,0) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to find if a number is whole | New Users to Excel | |||
| number anagram | Excel Worksheet Functions | |||
| Does the Wrap function in excel allow a maximum number of lines? | Excel Discussion (Misc queries) | |||
| Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
| how to write function to find max deviation from specific number . | Excel Worksheet Functions | |||
Linear Mode
