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.
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.