View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smckie
 
Posts: n/a
Default Max Value in a Row


Hello All,

I am trying to find the largest value in a row 78 and once that value
is found place the column header name (In Row 2) for that largest value
found back to the cell. Then I will find the 2nd largest value in the
same row... etc The following commands work (Sometimes):

=OFFSET(INDEX($78:$78,MATCH(LARGE($78:$78,1),$78:$ 78,0)),-76,0,1,1)
=OFFSET(INDEX($78:$78,MATCH(LARGE($78:$78,2),$78:$ 78,0)),-76,0,1,1)
=OFFSET(INDEX($78:$78,MATCH(LARGE($78:$78,3),$78:$ 78,0)),-76,0,1,1)
=OFFSET(INDEX($78:$78,MATCH(LARGE($78:$78,4),$78:$ 78,0)),-76,0,1,1)

In the case where there is more than one cell in row 78 with the same
value the function returns the first cell that satifies the equation
returning the same column name. I would like to be able to step to the
next column with the same value and return that columns name. So in the
case where there are three columns that have the same value in row 78, I
would like to see the names of all three columns.

Any ideas? Any help would be greatly appreciated

Regards

Scott


--
smckie
------------------------------------------------------------------------
smckie's Profile: http://www.excelforum.com/member.php...o&userid=32595
View this thread: http://www.excelforum.com/showthread...hreadid=523973