Thank you - job sorted.....

"Gary''s Student" wrote:

In B1 enter 1
in B2 enter:
=IF(A2=A1,B1+1,1)
and copy down
--
Gary''s Student
gsnu200707


"Polarbilly" wrote:

Hi,
I want to sequentially number cartons which comprise a customer order
e.g.
Column A(order No) Column B( carton No)
239114 1
239114 2
239114 3
456789 1
456789 2
456789 3
etc