Google Sheets - Identify Duplicates between Two Worksheets

Подписаться 52 тыс.

Просмотров 124 тыс.

50% 1

The VLOOKUP formula can help you find duplicated values between two sheets. This video will walk you through that process.
Here is the formula used: =VLOOKUP(C2,'identify duplicates two sheets 2'!$C$2:$C$21,1,false)
Use an add-on to manage duplicate: • Remove Duplicates (wit...
Learn more from Prolific Oaktree:
🌳 Next Video - create an interactive task list in Google Sheets • Google Sheets - Create...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/full-tu...
#googlesheets #duplicates #vlookup

Опубликовано:

20 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 40

@christianjunetubera665 2 года назад

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

@francosepulcri4283 9 месяцев назад

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

@kengarcia-oit3741 4 года назад

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

@ProlificOaktree 4 года назад

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

@karangoswami1776 3 года назад

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

@kesiah2870 3 года назад

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?

@Ajax4life251 4 года назад

Thank you, great and clear tutorial!

@TOM_EONIQ 2 года назад

Thanks for the video, simple and easy

@ProlificOaktree 2 года назад

You're welcome!

@ysayesound4346 3 года назад

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?

@adventureswithmemawngpaw137 2 дня назад

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!

@terb95 3 года назад

Thank you! This was very helpful!

@bharatbhushan3945 2 года назад

Very useful video thanks sir 🙏💕

@YO-mt9zw 3 года назад

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.

@Lucas-ee6rr 4 года назад

Great work mate. Keep up the good work

@ProlificOaktree 4 года назад

Thanks! Glad you liked it.

@faizaljamal 2 года назад

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

@Sumit.Singh3214 5 месяцев назад

thank you, great work👌

@ProlificOaktree 4 месяца назад

No problem 👍

@ibrahimar-rasyidramadhan5325 Год назад

hi, can we do it on 3 spreadsheets?

@ProlificOaktree Год назад

Only two at a time.

@OMORFIAorg 2 года назад

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

@ProlificOaktree 2 года назад

You would need to use the IMPORTRANGE function.

@Pearlune0 4 года назад

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 4 года назад

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 3 года назад

@@ProlificOaktree its not working :/

@pavoutsinas 4 года назад

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 4 года назад

Hard to tell without seeing the Sheet.

@pavoutsinas 4 года назад

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

@ProlificOaktree 4 года назад

@@pavoutsinas Ouch, that's painful!

@shanidyvasquez8108 3 года назад

Thank you so much!

@ProlificOaktree 3 года назад

You're welcome!

@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.

@assamali9594 4 года назад

VERY GOOD

@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.