Google Sheets - Identify Duplicates between Two Worksheets

[@christianjunetubera665]

Hi, thanks for this. Do you have a formula for highlighting duplicates from two different worksheets?

[@kengarcia-oit3741]

Thank you so much! Managing huge datasets and multiple sources of information, you just saved me hours of work.

[@ProlificOaktree]

Ooh yeah, you've gotta raise coming your way...

[@francosepulcri4283]

Hi, thanks for this. Do you have a formula for highlighting duplicates (Conditional formatting) from two different worksheets?

[@kesiah2870]

Hi, I tried it but I have a question the sheet 1 has a separate column for first and last then the sheet 2 they are combined. Will it still work?

[@karangoswami1776]

Really helpful, Can you help me this below problem?
I've two different workbooks how can I check for duplicates in Sheet1 from Workbook1 and Sheet2 from Workbook2

[@Ajax4life251]

Thank you, great and clear tutorial!

[@adventureswithmemawngpaw137]

I made a third sheet and got the duplicates to show there, now is there a way to make those disappear from the first sheet?

[@ProlificOaktree]

Not really!

[@ysayesound4346]

How do I apply this to large number of rows such as 1000? I can't really drag it, there's surely a quicker way?

[@terb95]

Thank you! This was very helpful!

[@bharatbhushan3945]

Very useful video thanks sir 🙏💕

[@TOM_EONIQ]

Thanks for the video, simple and easy

[@ProlificOaktree]

You're welcome!

[@Lucas-ee6rr]

Great work mate. Keep up the good work

[@ProlificOaktree]

Thanks! Glad you liked it.

[@OMORFIAorg]

Can you tell me how this will working with two different files in google sheets?

[@ProlificOaktree]

You would need to use the IMPORTRANGE function.

[@ibrahimar-rasyidramadhan5325]

hi, can we do it on 3 spreadsheets?

[@ProlificOaktree]

Only two at a time.

[@pavoutsinas]

I am getting incorrect data returned. I am trying to compare company names in two lists to find the missing names. I used UPPER formula to make both lists capitalized

[@ProlificOaktree]

Hard to tell without seeing the Sheet.

[@pavoutsinas]

@@ProlificOaktree2 hours in I finally figured out i had a filtered view enabled.. .. lol

[@ProlificOaktree]

@@pavoutsinas Ouch, that's painful!

[@Sumit.Singh3214]

thank you, great work👌

[@ProlificOaktree]

No problem 👍

[@YO-mt9zw]

Thanks. How to identify multiple repetitions i.e 15 repeated names between let's say 6 worksheets? I want to do it for a lot of people (400) as well. Thanks in advanced.

[@faizaljamal]

Awesome! thanks for the video, it was very helpful :)

[@Pearlune0]

When I go to the second worksheet, it doesn't let me select anything within the other formula, Google Sheets doesn't do it automatically. What do I do?

[@ProlificOaktree]

Type the formula out. Don't hit enter. When you get to the part of the formula to enter the range, use you mouse, go to the other sheets, click and drag, then continue with the formula.

[@aishathhananwaheed3532]

@@ProlificOaktree its not working :/

[@jessierichardson7551]

Did not work. EDIT: Got working. Did not see the comma insertion in the video, prior to range selection.

[@ProlificOaktree]

It would be more helpful if you describe exactly what you did, the result you desired, and the exact output you received instead of the desired result.

[@jessierichardson7551]

@@ProlificOaktree just updated that I got it working, but didn't notice the comma insertion part of the formula, before selecting your range. Thanks for the video though- aside from that one small thing, very helpful.

[@shanidyvasquez8108]

Thank you so much!

[@ProlificOaktree]

You're welcome!

[@assamali9594]

VERY GOOD

[@mercury8023]

Im so stupid. I cant get this working.

[@OscarPearson-w8k]

Didn't work

[@ProlificOaktree]

It would be more helpful if you describe exactly what you did, the result you desired, and the exact output you received instead of the desired result.