nth occurrence of MATCH
From the OP:
"Or perhaps have the formula read from right to left since it is the last
occurrence of that heading I want?"
Mike H wrote:
will give you the correct column number.
No it won't it will return the last match not the Nth
Mike
"Glenn" wrote:
The array formula (commit with CTRL+SHIFT+ENTER):
=MAX(IF(1:1="Avg MM Rate",COLUMN(1:1),""))
will give you the correct column number.
|