Number Duplicates (Multiple)
Assuming range starts from cell A1 downwards.
In B1 enter this formula and drag down.
=COUNTIF($A$1:A1,A1)
© Copyright
andrewsexceltips.net
All Rights Reserved.