View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default minimum value in a column, which row no?

Hi,

Try this

=MATCH(MIN($A$1:$A$100),$A$1:$A$100,0)

Now if your range starts other than in row 1 add an offset

=MATCH(MIN($A$10:$A$100),$A$10:$A$100,0)+9

The offset iss 1 less than the start row.

Mike

"Darius" wrote:

Using
Min (range) I can find the minimum value of a column of data. But how can I
find which Row number it belongs?