Find the Common Values between two lists in Excel using FILTER Function in Excel 365/Excel 2021

*The FILTER Function is used in available in Microsoft 365 and Excel 2021*
To compare two lists and extract common values, you can use a formula based on the FILTER and COUNTIF functions. This is one of the most simplest method of finding common values between two lists. Watch the complete tutorial of "Find the Common Values between two lists in Excel | MS Excel Made Easier" and let us know your queries in detail.

💡Logic behind the formula: In the above formula, we use the raw results from COUNTIF as the filter. This works because Excel evaluates any non-zero value as TRUE, and zero as FALSE. If COUNTIF returns a count greater than 1, the filter will still work properly.

#saartechnosoft #shorts #msexcel #msexceltutorial #office #office365 #youtubeshorts #searchable #xlookup #vlookup #hlookup #sumfunction #hiddenrows #tipsandtricks #excelheaderfooter #headerandfooter #inserheader #separatenames #splittingnames #transpose #msexcel #excel #msexceltutorial #microsoftoffice #tutorial #freetutorial #freecourse #freecertificate #msword #mspowerpoint #youtubeshorts #functions #formulas #excelshortcuts

Watch more trending videos:

❓Want to conduct training for your employees or yourself or looking for development services?
Call now: [phone], 8816817046

For more updates on courses and tips follow us on:

👉🏻Original Content by SAAR Technosoft Pvt. Ltd.

[SAARTech]

⚠ Note: *FUNCTIONS USED IN THE VIDEO WILL ONLY WORK ON EXCEL365*

[raziyapathan]

🤩Easy ho gaya iss method se. Achhi video hai!!

[ypliexl]

thanks baji yeh formula hamary bohat kam aya

[legentilmuyombo]

Great video
Is this possible in case we want to find common names instead?

[pppp-sfjk]

Why filter function is not available in my excell?

[ashishverma]

Formula lagane se acha hai...duplicate bhi use lr skte hai..

[syedshahriaramin]

What if we need the uncommon values? Please help, thanks

[KISHOREallpurposechannel]

What about if the one column in one sheet another column in another sheet. Then how?

[mohammadsalman]

What if we want to find unique value from both list ??? Whats the formula then

[gajendrasingh]

R u used in spreadsheet...bez filter formula not work in excel ...any other formula for excel

[EKSplorerph]

I tried this but function is invalid. 😢

[chandanjaiswal]

Mere excel me filter nahi aata hai plz help

[euplison]

Not working it is showing invalid function

[Wraichsaab]

List b merge ha tu o wo kaise search krenge