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
|