• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Remove duplicate with multiple criteria

Xlsin

New Member
Hi,

Can u please provide me a formula or vba of the below
I have duplicate value in column E. I want to create a formula and then a vba on the same.
For example 101 is a duplicate value. And we have two condition in column F. Based on the condition we have to remove the duplicate. So if 101 is a duplicate value and if column F has "a" and "b" criteria, the criteria b will be deleted first but if 101 has double"a" condition then also we will delete 101. But criteria b must be checked and then criteria A.
Please provide me a formula. I can do the vba code then or provide me vba code. Please write down the vba in thread.I am unable to open excel file.
 
Back
Top