View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J.Y.Joe J.Y.Joe is offline
external usenet poster
 
Posts: 1
Default 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.