EXCEL FORMULA PRO TIP: Fetch the Missing Values by Comparing Two Lists (With Duplicates List) | Dynamic Array Formulas Approach. =UNIQUE(FILTER($A$5:$A$12,COUNTIF($C$5:$C$10,$A$5:$A$12)=0)) Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel ua-cam.com/video/9uGPFmNhklw/v-deo.html
sir aapney to kaha tha k ye channel concepts ko urdu me elaborate krney k liye...logon ki help k liye ha...to sir please try to make videos in urdu so that people who dont understand english...can easily absorb such precious concepts.... Thank you.
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.
Thank you for sharing the knowledge, But I want to know is it possible to solve this problem without using filter function because I don't have Excel 365 ?
What is the formula for comparing each words in column? I mean if list 1 : quilted leather jacket and list 2 : leather shoes. So in both the list leather as a common word. Then how to extract that particular word. NOTE : That filter don't proceed to next row which means row 1 in both column a and b.
Rahim, i have a request if you could help please, i have list A with two columns list say names and cnic numbers and List B with one Column. I wish to extract common names with CNIC numbers of these names, wonder how to do that ??? Please help
First of all, Thank you for knowledge sharing. But there are 2 queries that need to be clarified. 1) I didn't find any Filter function in my excel sheet 2) Support if I have a list of repetitive names, how to extract a single name from that?
1. Dynamic arrays and the new functions below are only available Excel 365 and Excel 2021. Excel 2016 and Excel 2019 do not offer dynamic array formula support. 2. This is already discussed in the video.
EXCEL FORMULA PRO TIP: Fetch the Missing Values by Comparing Two Lists (With Duplicates List) | Dynamic Array Formulas Approach.
=UNIQUE(FILTER($A$5:$A$12,COUNTIF($C$5:$C$10,$A$5:$A$12)=0))
Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel
ua-cam.com/video/9uGPFmNhklw/v-deo.html
Clear and simple instructions, and not over-weighted with complex terms. Outstanding presentation. You saved me..again. :)
Start at 3:00 to see the solution. He uses the filter command. Thanks for sharing.
BAM!!!! Perfect! GREAT presentation!
Dude. This is the first time I have seen this. This deserves 1 million likes.
Thank you so much 🥰.
YAY! worked the best of all the videos I watched!
Nice trick, Rahim! Simple and Beautiful Solution!
Many many thanks
Thank you. This has helped me immensely
You're very welcome!
Happy Birthday Smart Boy
Thank you very much sir. You saved my life. I am stuck on a point for like 2 days.
You are most welcome
Perfect. Helped me do exactly as needed. Thank you for this!
You're welcome!
Thanks for sharing, this is what I was looking for. Thanks again.
You're welcome!
Thank you so much for this tutorial. This is just what I need for a spreadsheet project that I am working on.
Thank you. Perfect explanation. 🙏✨
You're very welcome!
GREAT VIDEO!!! Thank You 🙏🏼 🙏🏼🙏🏼
You are so welcome!
Oh, what an easy way it is!!!!!!
Amazing video. Thanks
Explaining complex formula in simple term without exaggerating.
What to do if we want to extract names which are not common in both the list?
It's more useful for me.. pls explain how to get different names ( compare 2 sheets)
sir aapney to kaha tha k ye channel concepts ko urdu me elaborate krney k liye...logon ki help k liye ha...to sir please try to make videos in urdu so that people who dont understand english...can easily absorb such precious concepts....
Thank you.
What will we do we have more than 3,4 columns to compare
That is also solved and video on this channel
Can you compare more than two
Lists?
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.
Good information!! What if you have 3 lists or more and you want to find the common denominator from all lists?
Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel
ua-cam.com/video/9uGPFmNhklw/v-deo.html
A cell in List A contains 3 names and in List B one of the names is dropped but I want it to appear as common list. How do you go around it?
Thank you for sharing the knowledge, But I want to know is it possible to solve this problem without using filter function because I don't have Excel 365 ?
If we have two different tables, in both have one common name but different roll. No. How would we extract specific
Sir, what if i want to compare more than 3 lists?
Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel
ua-cam.com/video/9uGPFmNhklw/v-deo.html
Sir, How to extract Unmatching names in different column
Did you get the answer for it can you plz tell me how we can check unmatched data
Same question here...
In Countif why criteria is list. What it would be the result
i have 2 columns - one is names and the other email addresses! they are all mismatched and need to match them correctly? thanks
What if, if i have 2 different spreadsheets?
trumpexcel.com/compare-two-columns/
How to perform same task for more than two columns??
Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel
ua-cam.com/video/9uGPFmNhklw/v-deo.html
I m having 2013 MS Office where FILTER function is not available, I want the same solution (extract village name from 2 sets). Please help me out.
Dynamic Array Formulas are available in Microsoft 365
What if they're in different worksheets? How can we solve that?
What is the formula for comparing each words in column? I mean if list 1 : quilted leather jacket and list 2 : leather shoes. So in both the list leather as a common word. Then how to extract that particular word.
NOTE : That filter don't proceed to next row which means row 1 in both column a and b.
Hi Can you Please help in extracting names match from 5 to 6 Columns.
Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel
ua-cam.com/video/9uGPFmNhklw/v-deo.html
Good information sir. If I want to extract from 3/4 columns, then what type of formula required?
www.get-digital-help.com/filter-common-values-from-three-columns-in-excel/
www.get-digital-help.com/wp-content/uploads/2009/08/Common-values-in-three-columns.xlsx
Download excel file and just copy formula sir. Its working fine
Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel
ua-cam.com/video/9uGPFmNhklw/v-deo.html
Salam Dear,
Sir, How to Compare Two Columns and Extract Differences
ua-cam.com/video/fVut66RTIWQ/v-deo.html
ua-cam.com/video/ANUS4bNMMLI/v-deo.html
trumpexcel.com/compare-two-columns/
@@ExcelBasement this is what I was looking for. Thanks a lot
How to get two different column word matching percentage in excel
In my excel it is showing invalid function ...why?
Same Name Match hota hai. Par kya Same Character hota hai match?
For Example : Contest and test = test
It shows That function is not valid
Any one can HELP ?
Rahim, i have a request if you could help please, i have list A with two columns list say names and cnic numbers and List B with one Column. I wish to extract common names with CNIC numbers of these names, wonder how to do that ???
Please help
I've excel 2016...can anyone give me the link of excel 365
First of all, Thank you for knowledge sharing. But there are 2 queries that need to be clarified.
1) I didn't find any Filter function in my excel sheet
2) Support if I have a list of repetitive names, how to extract a single name from that?
1. Dynamic arrays and the new functions below are only available Excel 365 and Excel 2021. Excel 2016 and Excel 2019 do not offer dynamic array formula support.
2. This is already discussed in the video.
If the names are repetitive use Unique function further
Hello sir I have done same procedure but got error " that function not valid "
same here
#### ERROR APPEARED 😞
Dynamic array formulas are only available in Excel 365.
Kitna bakwaas karta hai pahle