Number Duplicates (Single)

Assuming range starts from cell A1 downwards.

In B1 enter this formula and drag down.

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

Change 1 to suit.



© Copyright andrewsexceltips.net All Rights Reserved.