Automatically seperating duplicate values

[wmossuk]

Hi all. I am currently working on a final business project that involves me having a list of 30,000ish unique account references in column A. Weekly I distribute these to my colleagues own personal spreadsheets (also column A). Once these have been fully worked they no longer appear in the subsequent weeks report. The amount of accounts is never added to it only ever has completed accounts removed.

What I want is to have something in place on the master spreadsheet of mine which (ideally) automatically identifies which accounts are already on a different spreadsheet aswell so to avoid duplicating work for people.

Thanks

 

[Jude24]

Hello Wmossuk,

What version of excel are you using. More so, what do you mean by "amount of accounts is never added to it only ever has completed accounts removed."

Regards

 

[wmossuk]

Thanks for the reply, the version running in the office is 2007.

What I meant is that the pot of account numbers is never added to. Once an account has been completed it does not show up on the list of accounts that I receive the following week.

Does that make a bit more sense? (if i had 30 accounts and I completed one account in a week, the following report would show 29 account numbers)

 

[Jude24]

Your master spreadsheet will still have 30 accounts, but the new report you receive the following week will have 29 accounts.

Is this what you are expecting;

On your own worksheet ---------Subsequent worksheet
Account No: --------------------Account No:
Ntr001 ----------------- Ntr002
Ntr002 ----------------- Ntr003
Ntr004 ---------------- Ntr004

A vlookup formula could be used to achieve this.

Let me know if I understand the question properly.

Thank you

 

[wmossuk]

The main thing that I want is something to indicate whether an account on the master spreadsheet is also present on one of my colleagues workbooks (I have everyone as a tab on the one spreadsheet). Which will help me tell whether I have already handed the account over to them