You could flag them with a formula

B1: =IF(COUNTIF($A$1:A1,A1)1,"","X")

and copy down

--
HTH

Bob Phillips

"Amit Dhawan" <Amit wrote in message
...
How do I find unique values from column without using FILTER Option of
Excel?