Thread: Find values across a row and return a text value from the same column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Find values across a row and return a text value from the same column
On Tue, 19 Mar 2013 17:50:30 -0700 (PDT), zvkmpw wrote:

=INDEX($A$1:$J$1,1,MATCH(LARGE($A2:$J2,COLUMN()-10),$A2:$J2,0))

Not tested but I think you would get the same result, and not have it be dependent on the intial column, by using:

COLUMNS($A:A)

Reply With QuoteReply With Quote