Check 2 Columns for Positions and Departments on One Worksheet and Delete Instances Found On another

[marcweiss]

I have a workbook with multiple sheets. I need to check the "Requirements" sheet Columns A and B for matches on the Risk Mgmt sheet in the same columns A and B, if these entries are found on the Requirements sheet delete entire row. No actions need to occur with the data on the Risk Mgmt sheet.

Will be eternally grateful...I'm an Excel Novice so as specific of instructions as possible would be great.

 

[regresss]

Post an example as this is difficult to understand. It sounds like IF(X=Y,"",Z) AND ignoring blank rows (see http://www.mrexcel.com/forum/excel-questions/508325-how-ignore-blank-rows-array.html) could be your solution though.

 

[marcweiss]

Assume you mean:

Requirements Sheet Contains:
Column A - Job Title Column B -
RN I Pharmacy
RN II Anesthesiology
RN III Wound Care

Risk Management Sheet Contains:
Column A - Job Title Column B
RN I Pharmacy
RN II Anesthesiology
RN III Wound Care


If Data exists on both sheets (and it does....Thousands of rows) Delete all existence from Requirements Sheet - The entire row, not just the column.


Couldn't figure out how to attach the xls or I would have done that too.

 

[regresss]

IF(ISERROR(VLOOKUP(Requirements!A1,RiskManagement!A:A,1,0)),RiskManagement!A1,"")
into A1 in a new list and expand.

IF(ISERROR(VLOOKUP(RiskManagement!A1,Requirements!A:A,1,0)),Requirements!A1,"")
into B1 in the new list and expand.

Column A gives you all titles from Requirements not found in RiskManagements, Column B all titles from RiskManagements not found in Requirements. Next what you want to do is to merge these two columns into one and remove blank rows. You can google some formulas for that OR copy/paste data from column B below data in column A, mark the whole column, insert as a table and display without blanks (and zeros). This selection gives you all unique titles and can be copied in a new list.

 

[marcweiss]

Regresss thanks again and i'm sure its just that I'm not being very clear. I don't need to do anything with the Risk Mgmt sheet...I just inserted that page as a reference sheet. I need to be able to compare the Requirements sheet with it for matches in Column A & B.

So IF Risk Mgmt Column A & B = Requirements Column A & B THEN Delete row in Requirements

Does that help? I think that explains it better.