Hi Domenic,

Brilliant! Thank you very much.

Cheers,
Sam

Domenic wrote:
Based on your sample data, try the following...

P117:

=SUM(IF(MOD(ROW(F118:N133)-ROW(F118),3)=0,IF(F118:N133=50,1)))

...confirmed with CONTROL+SHIFT+ENTER

Q117, copied down:

=IF(ROWS(Q$117:Q117)<=P$117,SMALL(IF(MOD(ROW(F$11 8:N$133)-ROW(F$118),3)=0
,IF(F$118:N$133=50,F$117:N$132)),ROWS(Q$117:Q117) ),"")

...also confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

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