| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| minimum value column name look up | Excel Discussion (Misc queries) | |||
| Indicating the minimum and maximum on column charts | Charts and Charting in Excel | |||
| Find minimum value in column. | Excel Worksheet Functions | |||
| How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
| Header of column which has minimum in row? | Excel Discussion (Misc queries) | |||
Linear Mode
