Perhaps this formula coppied down...

=IF(COUNTIF(A:A, A1)=1, "", COUNTIF(A:A, A1))
--
HTH...

Jim Thomlinson


"Pierre" wrote:

Hi all.

I'm having a 'mare trying to write a query that will mark duplicates as
duplicates and triplicates as triplicates in a sorted column - see below

30460508
30460508
30460509
30460509
30460512
30460512
30460512
30460514
30460514
30460514
30460516
30460516
30460516
30460520
30460520
30460520
30460522
30460522
30460522
30460524
30460524


Say this is Cl A - what I want as output in Col B is 2 against the
duplicates and 3 against the triplicates.......

Any help gratefully recied.

Cheers