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".
.
|