Trying to return a column heading as a result using the INDEX command. It seems to work, but I get varying results. Only one cell (A2:L2) will contain a numeric value -- all others will be blank or contain a space. Any help is appreciate.
{=INDEX(A1:L1,MAX(IF(A2:L2"",COLUMN(A2:L2)-COLUMN(A1)+1)))}
Floki
{=INDEX(A1:L1,MAX(IF(A2:L2"",COLUMN(A2:L2)-COLUMN(A1)+1)))}
Floki