| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the row number of Median value of a column
I have over 150 rows of data with 20 columns and every three rows is made of
one group. In each group, I need to find the row which holds the meadian value of one of the column. Since I will do this for almost ten columns, I wonder if there is an easy way to do it. The Median function will only return the median value of the column and will not return the row number. Any suggestions? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the row number of Median value of a column
Maybe
=MATCH(MEDIAN(A:A),A:A,FALSE) Mike "J.Y.Joe" wrote: I have over 150 rows of data with 20 columns and every three rows is made of one group. In each group, I need to find the row which holds the meadian value of one of the column. Since I will do this for almost ten columns, I wonder if there is an easy way to do it. The Median function will only return the median value of the column and will not return the row number. Any suggestions? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return the row number of Median value of a column
The median value isn't necessarily a value that's in the range:
A1 = 1 A2 = 2 A3 = 3 A4 = 4 =MEDIAN(A1:A4) = 2.5 =MATCH(MEDIAN(A:A),A:A,FALSE) = #N/A -- Biff Microsoft Excel MVP "Mike H" wrote in message ... Maybe =MATCH(MEDIAN(A:A),A:A,FALSE) Mike "J.Y.Joe" wrote: I have over 150 rows of data with 20 columns and every three rows is made of one group. In each group, I need to find the row which holds the meadian value of one of the column. Since I will do this for almost ten columns, I wonder if there is an easy way to do it. The Median function will only return the median value of the column and will not return the row number. Any suggestions? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return column number from column header text | Excel Discussion (Misc queries) | |||
| To return the column number of a string | Excel Worksheet Functions | |||
| Look up values in a column and return ALL corresponding row number | New Users to Excel | |||
| In a column of numbers, how do I return the last non-zero number? | Excel Discussion (Misc queries) | |||
| Column() to return a letter instead of a number? | Excel Worksheet Functions | |||
Linear Mode
