Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick
Тәжірибелік нұсқаулар және стиль
In this Video learn how to use a single formula to find the matches & differences in two lists.
Software Tools/Products by Teknisha:
🔷 gumroad.com/teknisha🔷
Recommended Gadgets/Products:
www.amazon.in/shop/teknisha
Must Watch Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha_
Пікірлер: 71
This is the most concise and useful explanation I have managed to find on the subject. Thanks a million!
There’s always an Indian superhero to save the day when it comes to excel… thank you..
@TEKNISHA
2 ай бұрын
You are very welcome!!!
Amazing!! Just what I was searching for🤩 Thank you so much!!
this is incredible and really useful - thankyou for your time!
Thank you so much for posting - I'm very grateful.
SPECIAL Thanks for your supportive and excellent video tutor
This is the only video that actually enabled me to match names from two lists in a way that is easy to understand-thankyou. Is it true that to do this with v-lookup, if I have a spreadsheet without a common identifier (such as staff number) that I'm unable to do the match? I had two staff lists- one with unique identifiers, and one without.
This is so helpful, thanks!
Thank you for such a wonderful, complete, incredibly helpful solution to my problem!
Great video. Thank you for just getting down to business without glitzy futuristic star wars videos and music. I subscribed and look forward to seeing more.
Excellent step-by-step detailed explanation. Thank you! First time in your channel and looking forward to your content.
My long standing problem is solved with this concise and to the point explanation. Thanks a million. Kindly explain how do we apply this formula when we have more than two columns to compare.
Good video, clear explanation.
Love it, LOVE IT!! 😁
This is brilliant!
Phenomenally well explained and extremeley useful. Thank you!
@TEKNISHA
2 ай бұрын
Glad it Helped!!
After searching so many videos, finally arrived at this exact match.thank you
@TEKNISHA
2 ай бұрын
Glad this helped!!
Thank you for all your videos. You are a great trainer. Please how can I Compare two lists A and B in different workbooks? List A is the standard. If there are differences in List B, we copy the correct value from A to list B.
@tenamsb686
11 ай бұрын
Bring both of them into a third workbook using query/connection. (This will allow them to update by themselves if the content of either of those 2 workbooks updates). Then compare them using the method shared in the video. That's all. (Tip : Tables with specific names can be accessed anywhere through the workbook, doesn't need to be in the same worksheet.) P.S. : not sure if all this works in older versions of Excel, but sure about 365.
Best video on this subject by far!
@TEKNISHA
2 ай бұрын
Glad it Helped!!
Helped a lot
Wonderful job very clear and organized Thank you 🙏
@TEKNISHA
2 ай бұрын
You’re welcome 😊
Thanks Sir very helpful Sir if I have four to five lists and I want to compare it with main list and the extract names from main list which are not in other five lists
Thanks a lot!
You saved my day bro. great explanation
@TEKNISHA
2 ай бұрын
Glad I could help
Bro I think I need this video. Thnq u bhai
Thanks so much!!!
Thanku so much sir...
Excellent 👍😊
This is super.. It works well .. ! Thank you
@TEKNISHA
2 ай бұрын
Glad it helped!!
Thank you. Very helpful
@TEKNISHA
2 ай бұрын
Glad it was helpful!
what if the user does not have 365, is there another formula to get the same result? Thanks
Brother thanks a lot. Is this formula works on numbers
thanks a lot
What is the alternative to filter function
Thanks for this👌👌👌
@TEKNISHA
Жыл бұрын
Most welcome 😊
Congrats for 9 k subs sir 🥳👍🏻🥳🤟🏻
@TEKNISHA
2 жыл бұрын
Thank you Ansh….
@anshplays7939
2 жыл бұрын
@@TEKNISHA Anytime!!!
great help !
@TEKNISHA
2 ай бұрын
Glad it Helped!!
If list two had as an example, Andy (Name). How would I set my formula up so I tell excel to use contains Andy because if I am using 0 to return exact value it shows N/A
wonderful thank you boss
@TEKNISHA
2 ай бұрын
Most welcome
Thank you so much ... I could do my comparison ... 🤣
XMATCH automatically defaults to 0-Exact Match. So there is no need to type the ,0 in the formula when looking for an exact match.
What if I need to find out multiple information?
Saral bhasa me hota or v behtr lgta❤❤❤
I have multiple emails listed on single cells separated by commas, and I have a master file email list, I am trying to find common emails listed on the look up data that is present on the master file, those that are not listed on master file and those not listed on look up data. I understand the xmatch function however, there are multiple emails in a single cell and in master file just 1 email. Pls assist
Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?
i need 4th criteria where I should get unique from both tables and also the not unique values below them. in a new table.
What happens when the list has duplicate names? Will the result be messed up.
How does is work on google sheets?
I am having trouble saving the document when finished.
Why didn't u use only v look up?
please share the excel sheet
If list 1 double item ,so how we doing
Filter function is not in my excel
exodus as fawn time of distance versus changes of f.e.a.r assymptope, ISO TRADERS beware - causality of featuring, a lead expression of destiny/fate, sudoku error maker, gravijas of demi natured preference, use with care. Haiku#
I am too stupid to do this.
@bachim86
5 ай бұрын
Lol
How to use the same formula or list down common items, missing items etc for 3 or multiple columns instead only 2 column