how to create a new thread? please.
I suppose you did not enter the formula in col B with Ctrl+Shift+Enter
Hi, Thanks for the rating. I wasn't actually suggesting you do it manually, but merely put the Auto Filter/Delete method in a VBA macro. Post back if you can't work out how to do that. Regards