Hi pete,
Your formula is right
thank you very much
Sandy formula has equal result but one cell shift down(not side by side with
first repeated value).
Thank's sandy
best regards

"Pete_UK" wrote:

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