Return the row number of Median value of a column

[J.Y.Joe]

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.

 

[Mike H]

Maybe

=MATCH(MEDIAN(A:A),A:A,FALSE)

Mike

 

[T. Valko]

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