Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick

[@Mohashm]

There’s always an Indian superhero to save the day when it comes to excel… thank you..

[@TEKNISHA]

You are very welcome!!!

[@neildixon5748]

This is the most concise and useful explanation I have managed to find on the subject. Thanks a million!

[@briantran3000]

What happens when the list has duplicate names? Will the result be messed up.

[@ErinMartin-z4v]

I was searching forever to find this solution, thank you so much. I went through so many videos and all were only on outputting matches, not a list of unmatched. Perfection!

[@JinkyFlaviano]

what if the user does not have 365, is there another formula to get the same result? Thanks

[@d1psfx880]

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

[@HussamQazi]

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?

[@letthemgth]

what if I have to find common item from more than 2 columns?

[@rajeevgosavi4514]

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.

[@lythienghuo2876]

If list 1 double item ,so how we doing

[@kehaseneway7116]

SPECIAL Thanks for your supportive and excellent video tutor

[@anshplays7939]

Congrats for 9 k subs sir 🥳👍🏻🥳🤟🏻

[@TEKNISHA]

Thank you Ansh….

[@anshplays7939]

@@TEKNISHA Anytime!!!

[@mrinalrevoo8430]

Filter function is not in my excel

[@davidmiller849]

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.

[@chibimentor]

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#

[@Abdallah86F]

Wonderful job very clear and organized Thank you 🙏

[@TEKNISHA]

You’re welcome 😊

[@AwakenNpcBots]

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

[@mohitsandhu98]

You saved my day bro. great explanation

[@TEKNISHA]

Glad I could help

[@lmsaravanasundar5163]

How to use the same formula or list down common items, missing items etc for 3 or multiple columns instead only 2 column

[@uniprocrastination9232]

Thank you so much for posting - I'm very grateful.

[@soneeric6030]

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]

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.

[@giovanni-cx5fb]

Phenomenally well explained and extremeley useful. Thank you!

[@TEKNISHA]

Glad it Helped!!

[@sunilyaadav72]

excellent

[@nikhilrk8808]

After searching so many videos, finally arrived at this exact match.thank you

[@TEKNISHA]

Glad this helped!!

[@Lorenzo-cp7qs]

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.

[@danielosorio217]

Excellent step-by-step detailed explanation. Thank you! First time in your channel and looking forward to your content.

[@manishneupane3205]

wonderful thank you boss

[@TEKNISHA]

Most welcome

[@Hellobfflashes]

What if I need to find out multiple information?

[@alessio2999]

Best video on this subject by far!

[@TEKNISHA]

Glad it Helped!!

[@chapaperera7686]

This is super.. It works well .. ! Thank you

[@TEKNISHA]

Glad it helped!!

[@fts800]

Thank you for such a wonderful, complete, incredibly helpful solution to my problem!

[@mamatamahapatra9309]

Why didn't u use only v look up?

[@jasonmoses4784]

Thank you. Very helpful

[@TEKNISHA]

Glad it was helpful!

[@mjbell2010]

I am having trouble saving the document when finished.

[@mar25947]

Love it, LOVE IT!! 😁

[@AbbisettiVijayaSurendraKumar]

i need 4th criteria where I should get unique from both tables and also the not unique values below them. in a new table.

[@nmlbajaj]

Very helpful ! Thank you so much !

[@Shafiudding]

Brother thanks a lot. Is this formula works on numbers

[@NeLzKieTV]

Thanks for this👌👌👌

[@TEKNISHA]

Most welcome 😊

[@RogerMorelli]

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.

[@speedyr826]

This is so helpful, thanks!

[@rafae1pe]

great help !

[@TEKNISHA]

Glad it Helped!!

[@Raunak00007]

Saral bhasa me hota or v behtr lgta❤❤❤

[@venkatiyer7459]

Thank you so much ... I could do my comparison ... 🤣

[@MrABD-we9yn]

Bro I think I need this video. Thnq u bhai

[@excelhacks365]

How does is work on google sheets?

[@GeorgeAJululian]

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

[@tedmoy]

Great video!

[@Mary77129]

Amazing!! Just what I was searching for🤩 Thank you so much!!

[@BrumCraft]

This is brilliant!

[@EricPardo]

Thanks so much!!!

[@ventata2008]

Thanku so much sir...

[@georgerichardson633]

this is incredible and really useful - thankyou for your time!

[@jitheshj6870]

What is the alternative to filter function

[@chiragkolambe3520]

please share the excel sheet

[@acaciaapril]

thanks a lot

[@huseyinburaktasci1638]

Thanks a lot!

[@marctemura2017]

Good video, clear explanation.

[@manojkumar-cp4mf]

Excellent 👍😊

[@Rods_From_God]

Helped a lot

[@chicagomike]

I am too stupid to do this.

[@bachim86]

Lol