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 2004 - 2010,
andrewsexceltips.net
All Rights Reserved.