Finding Duplicates Across Multiple Worksheets

[Valencia522]

Hi,

I'm new to the forum and have a dilemma. My supervisor wants me to look for duplicate client numbers across four worksheets from a master sheet and I don't know where to start! I don't even know what formula to use. Here's the kicker, there are 2,992 client numbers in one column!!!! There's no way I can look these up one-by-one. Is there a way to highlight the column with the client numbers and put in a formula at the bottom to look for duplicates in the other four worksheets? HELP!!

[KOKOSEK]

probably can be easier way but it should work:

=IF(OR(IFERROR(VLOOKUP(MasterSheet!A2,Sheet1!A:A,1,0),0),IFERROR(VLOOKUP(MasterSheet!A2,Sheet2!A:A,1,0),0),IFERROR(VLOOKUP(MasterSheet!A2,Sheet3!A:A,1,0),0),IFERROR(VLOOKUP(MasterSheet!A2,Sheet4!A:A,1,0),0)),"duplicated","")

On Mastersheet data from col. A is check in col. A in Sheet1,2,3,4.

[Valencia522]

Thanks KOKOSEK. Will this formula go at the bottom of the column where the claim id's are in the master sheet? I'm a dummy when it comes to Excel as you can see.

[JeteMc]

Here is an example of how KOKOSEK's formula may be applied.
Let us know if you have any questions.

[Valencia522]

Thanks but I don't think this will work. I sincerely appreciate you!!

[JeteMc]

Please explain what "don't think this will work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

If we could see a sample .xlsx file that shows some expected results we may be able to offer better proposals. Instructions for uploading a file are given in the banner at the top of the page.
Let us know if you have any questions.