Hello all,

I need to delete the repeated items in Col. A


(this is just a simplified version, my data can beup too 100 Rows.)
I have a thought of using double loops,but this didn't help as all items are treated as repeated items.

Now I have no idea abt this.

Help will be appreciated,thanks.