I have four columns. If column D contains the numeral 1, I want a macro that will either retain it or delete it based on the following criteria
For example, say D1 contains a 1. Then the macro should look at offset C1 to see if it is the same name as in offset B1. If so move on.
If not, then the macro should note the value in A1. Say that value is 3.
If any names in column B that have a value of 3 in column A, match the name in C1 which also has a value of 3 (in this case) then the “1” in D1 should be deleted.
Then go down the list which contains 200 names.
Thanks
For example, say D1 contains a 1. Then the macro should look at offset C1 to see if it is the same name as in offset B1. If so move on.
If not, then the macro should note the value in A1. Say that value is 3.
If any names in column B that have a value of 3 in column A, match the name in C1 which also has a value of 3 (in this case) then the “1” in D1 should be deleted.
Then go down the list which contains 200 names.
Thanks