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:
⏩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.
Пікірлер: 69
⚠ 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 - kzread.infok8Tu6CsVcVA?si=k3ydpiGA8_mk2EO1
Great Video!💗💗
@SAARTech
2 жыл бұрын
Glad you liked it!!
Great video
🤩Easy ho gaya iss method se. Achhi video hai!!
Impressive video
Great video ☺☺
Nice❤
Thanks a lot
Great
@SAARTech
10 ай бұрын
Thank you 😊
thank you
@SAARTech
9 ай бұрын
You're welcome
Thank you 😊
@SAARTech
Жыл бұрын
Welcome!
👍👍
thanks baji yeh formula hamary bohat kam aya
@SAARTech
11 ай бұрын
🙏🙏🙏🙏🙏
Thanks, it was useful
@SAARTech
Жыл бұрын
Glad to hear that!
Formula lagane se acha hai...duplicate bhi use lr skte hai..
@SAARTech
10 ай бұрын
There are number of ways to solve a problem. Choose as per your ease and requirement. Appreciate your addition 😊
What if we need the uncommon values? Please help, thanks
@SAARTech
10 ай бұрын
@syedshahriaramin8203 please check the channel, i have already shared short on the topic. Hope it will help😊
@All_about_Life._.
8 ай бұрын
How to copy the filtered values into another sheet??
I need the quantity of same value
@SAARTech
9 ай бұрын
Use countif to count same value in a range.i hope it will work for you 😊
It's not working
@SAARTech
3 ай бұрын
Please check your version
R u used in spreadsheet...bez filter formula not work in excel ...any other formula for excel
@SAARTech
Жыл бұрын
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. 😢
@SAARTech
11 ай бұрын
The FILTER Function is used in available in Microsoft 365 and Excel 2021. Please check the description.
What about if the one column in one sheet another column in another sheet. Then how?
@SAARTech
Жыл бұрын
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 😊
@KISHOREallpurposechannel
Жыл бұрын
@@SAARTech Thank you🤝 and waiting for your video
@SAARTech
Жыл бұрын
The new video is out now! kzread.info/dash/bejne/fZx7wbGPYs-6qJc.html
@ajjosh3548
Жыл бұрын
You could make both ranges into named ranges and call it in ur formula
Will this work for text
@SAARTech
Жыл бұрын
@sarthaksarode3982 Yes , it will work for text as well.
Mere excel me filter nahi aata hai plz help
@SAARTech
Жыл бұрын
Office 365 mein hai yeh function. Aap kon sa version use kr rahe hai
Can we use vlookup 🤔
@SAARTech
Жыл бұрын
Dealing with two lists using vlookup could be tricky as vlookup has its own restrictions. If you have used it, please share with us. 😊
Great video Is this possible in case we want to find common names instead?
@SAARTech
Жыл бұрын
Yes, you can find common names using the same formula between two lists. Thanks for asking 😊😊
@SAARTech
Жыл бұрын
The new video is out now! kzread.info/dash/bejne/fZx7wbGPYs-6qJc.html
What if we want to find unique value from both list ??? Whats the formula then
@SAARTech
Жыл бұрын
To find unique values from both the lists, use filter and countif function.
Not working it is showing invalid function
@SAARTech
Жыл бұрын
Which version of excel are you using
not working
@SAARTech
Жыл бұрын
Please share screenshot of your problem and which version of Excel are you using?
List b merge ha tu o wo kaise search krenge
@SAARTech
8 ай бұрын
Can you please share screenshot?
@wraichsaab8105
8 ай бұрын
@@SAARTech I will tomorrow
@SAARTech
8 ай бұрын
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
how will get non common values
@SAARTech
Жыл бұрын
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
@SAARTech
11 ай бұрын
Thank you 😊
Uncommon ?
@SAARTech
11 ай бұрын
@isbwikipedia kindly check previous replies. You'll find the solution there.
Can I get ur contact pls
@SAARTech
Жыл бұрын
Hi, dear. You can visit the channel page for all the contact information.😊
Not working
@SAARTech
Жыл бұрын
@huzaifaphontom6528 what error are you getting and which version are you using
@huzaifaphantom6528
Жыл бұрын
@@SAARTech 2016 and there is no function named filter
@SAARTech
Жыл бұрын
@huzaifaphontom6528 it is available in Microsoft 365 and excel 2021 that's why it is not working.
@huzaifaphantom6528
Жыл бұрын
@@SAARTech maybe