I am attempting to determine how or even if I can do something. I have a sheet with 4 columns of data. Column A and Column B are related to each other and Columns C and D are related to each other. What I am attempting to do is compare the data in Column B with the data in Column D (all rows) and if a match is found Delete the Data in column A and B for that row only. Then move onto the Next Row until complete (30,000 cells which I am attempting to do manually). In other works steping down the rows looking for matches to the data in Column B.
The end result would be the data that remains in Column A and B would only be data that did not match anything when column B is compared to ALL of Column D.
Any guidance would be appreciated, since my Excel skills are near Zero.
Thanks in Advance
Bookmarks