View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NBVC[_56_] NBVC[_56_] is offline
external usenet poster
 
Posts: 1
Default select max value from row of data and column containing max value


To get name associated with Max...

=Index(A$1:D$1,Match(Max(A2:D2),A2:D2,0))

To get Max

=Max(A2:D2)

To get 2nd Largest:

=Large(A2:D2,2)

To get name associated with 2nd largest:

=Index(A$1:D$1,Match(Large(A2:D2,2),A2:D2,0))


where A1:D1 contain the name headers...

A2:D2 begin the metrics...

All formulas can be copied down


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111092