Hi Domenic,

Thank you very much. That's Great! Works a treat!


Cheers,
Sam

Domenic wrote:
Maybe...

=MAX(IF(ISNUMBER(MATCH(G17:G24,INDEX(Data,MATCH(H 13,ID,0),0),0)),H17:H24))

and

=MIN(IF(ISNUMBER(MATCH(G17:G24,INDEX(Data,MATCH(H 13,ID,0),0),0)),H17:H24))

Note that both formulas need to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER.

Hope this helps!

Hi Biff,

[quoted text clipped - 13 lines]
Cheers,
Sam

--
Message posted via http://www.officekb.com