Thread: minimum value in a column, which row no?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default minimum value in a column, which row no?
Assuming your data column is A, try the below

=MATCH(MIN(A:A),A:A)


If this post helps click Yes
---------------
Jacob Skaria


"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?
Reply With QuoteReply With Quote