Find the Common Values between two lists in Excel using FILTER Function in Excel 365/Excel 2021
HTML-код
- Опубликовано: 21 июн 2022
- 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:
⏩Watch Complete One-minute Series: • One-Minute Series
⏩Watch our FREE Webinar Series here: • Free Webinar Series
⏩Top Internships Available for Computer Science Students: • Top Internships Availa...
⏩Top 10 Technologies to Learn in 2021: www.youtube.com/watch?v=3tAw1...
⏩Watch our previous live streams here: • Live Streams
⏩Become a Digital Marketing Expert for FREE: • Digital Marketing Tips
❓Want to conduct training for your employees or yourself or looking for development services?
Call now: +91 9996938062, 8816817046
Explore certification courses and other services from SAAR Technosoft 👉: www.saartechnosoft.com
For more updates on courses and tips follow us on:
🤩Facebook: / technosoft.saar
🤩Twitter: / technosoftsaar
🤩LinkedIn: / saartechnosoft
🤩Instagram: / saartechnosoft
👉🏻Original Content by SAAR Technosoft Pvt. Ltd. - Хобби
⚠ Note: *FUNCTIONS USED IN THE VIDEO WILL ONLY WORK ON EXCEL365*
To check how to find uncommon values, watch: Finding Uncommon Values Between Two Rows - ruclips.net/user/shortsk8Tu6CsVcVA?si=k3ydpiGA8_mk2EO1
Great video
Great Video!💗💗
Glad you liked it!!
🤩Easy ho gaya iss method se. Achhi video hai!!
Impressive video
Great video ☺☺
Nice❤
Thanks a lot
thanks baji yeh formula hamary bohat kam aya
🙏🙏🙏🙏🙏
Great
Thank you 😊
👍👍
Thank you 😊
Welcome!
Thanks, it was useful
Glad to hear that!
thank you
You're welcome
Great video
Is this possible in case we want to find common names instead?
Yes, you can find common names using the same formula between two lists. Thanks for asking 😊😊
The new video is out now! ruclips.net/video/KhG_OV2lTx4/видео.html
What if we need the uncommon values? Please help, thanks
@syedshahriaramin8203 please check the channel, i have already shared short on the topic. Hope it will help😊
How to copy the filtered values into another sheet??
What if we want to find unique value from both list ??? Whats the formula then
To find unique values from both the lists, use filter and countif function.
Formula lagane se acha hai...duplicate bhi use lr skte hai..
There are number of ways to solve a problem. Choose as per your ease and requirement. Appreciate your addition 😊
What about if the one column in one sheet another column in another sheet. Then how?
Then also it is applicable but use sheet name properly. video explaining this will be published on Monday . please go through it. hope it will help you. Thanks for asking 😊
@@SAARTech Thank you🤝 and waiting for your video
The new video is out now! ruclips.net/video/KhG_OV2lTx4/видео.html
You could make both ranges into named ranges and call it in ur formula
Will this work for text
@sarthaksarode3982 Yes , it will work for text as well.
I need the quantity of same value
Use countif to count same value in a range.i hope it will work for you 😊
Can we use vlookup 🤔
Dealing with two lists using vlookup could be tricky as vlookup has its own restrictions. If you have used it, please share with us. 😊
R u used in spreadsheet...bez filter formula not work in excel ...any other formula for excel
Filter function is used in excel. The FILTER function is only available in Excel for Microsoft 365 and Excel 2021. In Excel 2019, Excel 2016 and earlier versions, it is not supported.
I tried this but function is invalid. 😢
The FILTER Function is used in available in Microsoft 365 and Excel 2021. Please check the description.
Mere excel me filter nahi aata hai plz help
Office 365 mein hai yeh function. Aap kon sa version use kr rahe hai
Not working it is showing invalid function
Which version of excel are you using
It's not working
Please check your version
List b merge ha tu o wo kaise search krenge
Can you please share screenshot?
@@SAARTech I will tomorrow
If you have merged lists then also use the formula in the same manner. It will work. In case you face any problem then share your problem. Will definitely try to solve it
Uncommon ?
@isbwikipedia kindly check previous replies. You'll find the solution there.
not working
Please share screenshot of your problem and which version of Excel are you using?
how will get non common values
use filter and countif function in the same way , just equate countif=0 e.g =FILTER(A2:A12,COUNTIF(C2:C12,A2:A12)=0). Hope it will help
Thank you 😊
Not working
@huzaifaphontom6528 what error are you getting and which version are you using
@@SAARTech 2016 and there is no function named filter
@huzaifaphontom6528 it is available in Microsoft 365 and excel 2021 that's why it is not working.
@@SAARTech maybe
Can I get ur contact pls
Hi, dear.
You can visit the channel page for all the contact information.😊