Hi Mike,

Thanks again for further assistance.

I've tried the ISERROR formula solution, it does provide a sequential count
but does not return the required zero (0).

Further assistance appreicated.

Cheers,
Sam

Mike H wrote:
Sam,

Wrapping the whole thing in iserror seems to work for your data layout, try
this

=IF(ISERROR(IF(AND(A4="C",A3=$D$1,OFFSET(A4,$D$ 1*-1,0)=$D$1,OFFSET(A4,($D$1*-1)+1,0)="C"),0,C3+1)),C3+1,IF(AND(A4="C",A3=$D$1,O FFSET(A4,$D$1*-1,0)=$D$1,OFFSET(A4,($D$1*-1)+1,0)="C"),0,C3+1))

This now includes absolute references to D1 which is the search No and also
the amount of rows the dormula looks back to find the previous match.

Mike

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