Hi Domenic,

Superb! And as Biff said, WOW!

Thank you for your time and all your help.

Cheers,
Sam

Domenic wrote:
In that case, we'll only need the following references for the defined
names...

Select G7
Insert Name Define
Array1:
=ROW(INDEX(Sheet2!$A:$A,1):INDEX(Sheet2!$A:$A,COL UMNS(Data)))

Array2:
=INDEX(Data,ROWS(Sheet2!$G$7:$G7),0)

Array3:
=10^(Array1*LEN(Sheet2!G$5+1))/10^LEN(Sheet2!G$5+1)

Then, use the following formula instead...
G7, copied down and across:
=IF(ISNUMBER(MATCH(G$5,Array2,0)),SUBSTITUTE(SUMP RODUCT(LARGE(IF(Array2=G
$5,G$5+1,0),Array1),Array3),G$5+1,G$5),"")

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Hi Domenic,

[quoted text clipped - 20 lines]
Cheers,
Sam

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