Dear all,

I have a huge data in my excel I need to delete, I have an identify
formula, countif, for the data in column B. I wish to delete the
repeat one, and the result in countif would be larger than 0. How I
can write a vba code to delete the result in column A large than 0?

thanks

Vincent