|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 22nd, 2009, 05:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
|
#2
April 22nd, 2009, 05:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#3
April 22nd, 2009, 05:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#4
April 22nd, 2009, 05:43 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#5
April 22nd, 2009, 05:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#6
April 22nd, 2009, 06:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#7
April 22nd, 2009, 06:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
