View Single Post
  #5   Report Post  
Jason Morin
 
Posts: n/a
Default

You're right. I habitually press ctrl/shift/enter on most
of my INDEX formulas w/out examining the need for it
first. Good catch.

Jason

-----Original Message-----
Jason Morin wrote:
With values in row 2 and headers in row 1:

=INDEX(1:1,MATCH(MIN(2:2),2:2,0))

Array-entered.


That shouldn't require to be "array-entered".
.