View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default nth occurrence of MATCH

Apologies you are correct i was focussed on the message header asking for the
Nth occurrence

"Glenn" wrote:

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.