Hi Domenic,

Thank you very much - solution worked a treat - Brilliant!

Cheers,
Sam

Domenic wrote:
Let G18:H18 contain 50 and 54

G19, copied across:
=IF(E19=G$18,1,0)

G20, copied down and across:
=IF(E20=G$18,G19+1,0)

Let J18:L18 contain 2, 3, and 4
Let I19:I20 contain 50 and 54

J19, copied down and across:
=SUMPRODUCT(--(OFFSET($G$19:$G$34,0,MATCH($I19,$G$18:$H$18,0)-1)=J$18),--
(OFFSET($G$19:$G$34,1,MATCH($I19,$G$18:$H$18,0)-1)=0))

Hope this helps!

Hi All,

[quoted text clipped - 57 lines]
Cheers,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1