Finding duplicate data and deleting

[seanobrathvilly]

Hi Everyone,

I was wondering is there anyway of finding particular data from a data set and deleting the data from that field without using conditional formatting or remove duplicates? A formula I think is the jey


I have used a vlookup to find the words that I needed I now need to find where the are located in my original data set and delete these so I am left with data that if I perform a vlookup on it will not bring back any words as they will have been deleted.

Thanks

[AlKey]

H seanobrathvilly,

I would suggest you try built-in excel feature Remove Duplicates located under the Data tab on the ribbon.

[xladept]

With VBA we can replace every instance of an unwanted entry with a null, would that work for you?

[seanobrathvilly]

Hey xladept, that should work. Only problem is I am terrible with VBA Alkey, I tried that but it doesnt remove what I want.

[xladept]

Post a sample spreadsheet, and we'll try to code it for you

[Josh1759]

Thanks to everyone. I got it

[Hawko1973]

Dear All,

Any chance of sharing it (the successful solution that it) with the 'Community'..... After all, it 'is' the reason why we come here isn't it? To learn.....

Looking forward to it.

H.