Originally Posted by reyz007

.
hhh, very simple

just copy column B into column A and run data>filter>advanced filter

condition e. g. <>""

and check unique records only

106522520, i can do it for you
.