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.

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.

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.