View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren Darren is offline
external usenet poster
 
Posts: 137
Default Reference between rows, not columns

To simplify:
With a list of names in column A and scores in column B, I know using
=INDEX(A:A,MATCH(MAX(B:B),B:B,FALSE,)1) I can see who has the highest score.
My problem is, I want to do the same thing but across rows so that in the
example the names would be in row 1 with the scores in row 2.

Any help would be greatly appreciated.