minimum value in a column, which row no?
 

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

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?

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?

minimum value in a column, which row no?
 

=MATCH(MIN(A:A),A:A,0) for exact match
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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?

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?

minimum value in a column, which row no?
 

Technically, since he's finding the MIN from same range your matching to, is
there a need to callout for "exact" match?
--
Best Regards,

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


"Jacob Skaria" wrote:

=MATCH(MIN(A:A),A:A,0) for exact match
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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?

minimum value in a column, which row no?
 

Try it with these numbers in A1:A5 -

18,20,87,11,41

=MATCH(MIN(A1:A5),A1:A5)

--
Biff
Microsoft Excel MVP


"Luke M" wrote in message
...
Technically, since he's finding the MIN from same range your matching to,
is
there a need to callout for "exact" match?
--
Best Regards,

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


"Jacob Skaria" wrote:

=MATCH(MIN(A:A),A:A,0) for exact match
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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?