incremental counter

I have seen this befroe but can not locate. I need to implement a counter
based on a previose cell. If it have

123
123
124
125
125
125
125
I need
123 1
123 2
124 1
125 1
125 2
125 3
125 4

Try something like this:

B2: =IF(A2<>A1,1,B1+1)
copy down as far as needed

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"cynthiabryant" wrote:

> I have seen this befroe but can not locate. I need to implement a counter
> based on a previose cell. If it have
>
> 123
> 123
> 124
> 125
> 125
> 125
> 125
> I need
> 123 1
> 123 2
> 124 1
> 125 1
> 125 2
> 125 3
> 125 4

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


"cynthiabryant" wrote:

> I have seen this befroe but can not locate. I need to implement a counter
> based on a previose cell. If it have
>
> 123
> 123
> 124
> 125
> 125
> 125
> 125
> I need
> 123 1
> 123 2
> 124 1
> 125 1
> 125 2
> 125 3
> 125 4

Thanks that did the trick

"Gary''s Student" wrote:

> in B1 put 1
> in B2 put:
> =IF(A2=A1,B1+1,1)
> and copy down
> --
> Gary's Student
>
>
> "cynthiabryant" wrote:
>
> > I have seen this befroe but can not locate. I need to implement a counter
> > based on a previose cell. If it have
> >
> > 123
> > 123
> > 124
> > 125
> > 125
> > 125
> > 125
> > I need
> > 123 1
> > 123 2
> > 124 1
> > 125 1
> > 125 2
> > 125 3
> > 125 4

if your series starts in A1, then B1 = 1 and B2 would be
=IF(A2=A1,B1+1,1)

"cynthiabryant" wrote:

> I have seen this befroe but can not locate. I need to implement a counter
> based on a previose cell. If it have
>
> 123
> 123
> 124
> 125
> 125
> 125
> 125
> I need
> 123 1
> 123 2
> 124 1
> 125 1
> 125 2
> 125 3
> 125 4