what i am trying to do is to delete duplicate rows, but not just in the ordinary fashion. I want to search for duplicates based on cell contents in column A and C and then delete whichever duplicate contains the phrase "discontinue" in column E
So, if the contents in column A and C match for two rows then I want the macro to look to column E and delete whichever duplicate contains the word "discontinue"
I searched the forums and only found regular delete duplicates macros and nothing that will do just this.
Thanks for any help!
So, if the contents in column A and C match for two rows then I want the macro to look to column E and delete whichever duplicate contains the word "discontinue"
I searched the forums and only found regular delete duplicates macros and nothing that will do just this.
Thanks for any help!