2 workbooks: Commissions needing paid and commissions paid - comparison/deleting

Hi there! I'm a total noob to Excel, going to classes soon for it but I need someone's help. I have 2 workbooks, one with serial numbers that are owed commissions on, the second with a list of serial numbers that have been paid. I need a way to weed those that have been paid out. I don't really care if they are deleted or if the unique (still not paid commissions) are highlighted or whatever. I'm not sure what the best way would be to go about this.

Serial numbers needing paid are in column H on the "devices owed commissions" and the serial numbers for the devices that have been paid are in column I of the "comm paid"

New workbooks will be generated weekly so I need to be able to repeat the process every week.

Thank you all so much for your help!Comm PAID.xlsx

DEVICES OWED COMMISSIONS.xlsxAttachment 429607

Perhaps like this?

In workbook "Devices owed commisssions.xlsx" selct cell A1, then select "Data" tab and click "Filter". This will set an autofilter on all your data.

Scroll to column "O" and click on dropdown arrow in cell O1. Click on box marked "Select All", then you click on box marked "paid".

In the speadsheet you will now see only the rows with result "paid" in column O.

If you delete these rows and then click on "Filter" the autofilter settings dissapear and you are left with only the rows that have status "nga"

Alf

Thank you for responding Alf, that column "O" actually has to do with the customer and what they paid. I'm sorry for not clarifying. Column H on the devices owed commission is the important part of the sheet that is populated, it lists the serial numbers that I need to match to column I on the commissions paid sheet. Maybe that will help. I can always copy and paste the one sheet to a separate sheet in the same workbook of the other if that helps. I just need to weed out the devices that haven't been paid yet so I can appeal them to be paid. Does that help?

Ok so I copied values in column I file "Comm Paid.xlsx" and incerted a number of columns in the "Device Owed Commision.xlsx"

I then sorted this range J2 to J 1410 and used a vlookup formula in column I with the "True" setting for vlookup. This ensures you will get an exsact match, if not you get an "#N/A" error so all rows with this value is the one that has not paid.

Perhaps this will suit you better?

Alf

That looks great Alf! Thank you so much!