ExcelBanter - function to find the row number of the maximum value in a coll

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - function to find the row number of the maximum value in a coll (https://www.excelbanter.com/excel-worksheet-functions/127345-re-function-find-row-number-maximum-value-coll.html)

josht

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

All times are GMT +1. The time now is 09:30 PM.