Quote Originally Posted by AliGW View Post
=COUNTIF($A$1:A1,A1,A$1:A1)

In B1 and copied down.
Ali, this was your formula, right?
Formula: copy to clipboard
=COUNTIFS($A$1:A1,A1)