View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default minimum value in a column, which row no?

Returns first row that contains mim value (if two rows have same min value,
will only display first row)

=MATCH(MIN(A:A),A:A)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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?