How to find duplicates across multiple worksheets on a mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2340506%22%20slang%3D%22en-US%22%3EHow%20to%20find%20duplicates%20across%20multiple%20worksheets%20on%20a%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340506%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20file%20that%20has%20over%20100%20entries%20in%20each%20column%20across%20multiple%20sheets.%20Is%20there%20a%20easy%20way%20to%20find%20duplicates%20across%20these%20sheets%3F%20Some%20of%20these%20columns%20have%20accounts%20listed%20twice%20within%20them%20but%20I%20am%20looking%20to%20to%20compare%20these%20sheets%20and%20quickly%20identify%20the%20duplicates.%26nbsp%3B%20I%20tried%20conditional%20formatting%20but%20all%20it%20does%20is%20finds%20duplicates%20within%20a%20column%20not%20across%20sheets.%20I%20attached%20a%20rough%20sample%20of%20what%20it%20might%20look%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2340506%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2342274%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20find%20duplicates%20across%20multiple%20worksheets%20on%20a%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2342274%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1049693%22%20target%3D%22_blank%22%3E%40Carlin21%3C%2FA%3E%26nbsp%3B%20I%20could%20provide%20further%20details%20if%20necessary!%20this%20is%20urgent%20please!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have this file that has over 100 entries in each column across multiple sheets. Is there a easy way to find duplicates across these sheets? Some of these columns have accounts listed twice within them but I am looking to to compare these sheets and quickly identify the duplicates.  I tried conditional formatting but all it does is finds duplicates within a column not across sheets. I attached a rough sample of what it might look like.

2 Replies

@Carlin21  I could provide further details if necessary! this is urgent please!

 

@Carlin21 

 

exampleRevised1.xls = using vlookup

exampleRevised2.xls= using power query

 

Power Query is less work