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