Hi Pete,

Yes you are quite correct that is exactly what I did do. My apologies.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pete_UK" wrote in message
...
Sandy,

works okay for me. Did you put it in B2?

Pete

On May 28, 1:20 pm, "Sandy Mann" wrote:
Sorry Pete, I omitted your name at the beginning:

Pete,

Your formula returns 2 for the 3 355's

=IF(AND(A1=A2,A2<A3),COUNTIF($A$1:A2,A2),"")

in A2 and copied down will return the Op's results but if there are
duplicate number further down the list it will give the total of that
number to that point not just the latest series

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Sandy Mann" wrote in message

...



Your formula returns 2 for the 3 355's

=IF(AND(A1=A2,A2<A3),COUNTIF($A$1:A2,A2),"")

in A2 and copied down will return the Op's results but if there are
duplicate number further down the list it will give the total of that
number to that point not just the latest series.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

"Pete_UK" wrote in message
...
Try this in B1:

=IF(COUNTIF(A$1:A1,A1)=1,COUNTIF(A$1:A$16000,A1)," ")

and then copy down to B16000.

Hope this helps.

Pete

On May 28, 12:29 pm, climate
wrote:
I have 1 column (A), with 16000 rows and repeated value, i need to
count
repeated value and write this in column B, for example:

A B
222 2
222
355 3
355
355
420 2
420

best regards- Hide quoted text -

- Show quoted text -