This just helped me a bunch to distinguish between the contents of two Spotify playlists, when I accidently deleted a third one which had my favorite songs!!!
I've always wanted to know a reliably effective method of doing this in a spreadsheet. This is super-easy to do with Microsoft Access, but its a pain in the neck to import data into Access, do my thing, and export what I need later. The more I can do in Excel, the better. KICK BUTT tutorial, good sir!
Great video, and a useful illustration of the power of the filter function. One thing to be wary of, this method only checks the id field. So it won't show records that have different data recorded against the same id in Mylist and in ColleaguesList
Hi thanks for watching and commenting. It is really appreciated. Yes I agree, I would us a slightly different method if I was comparing the whole row. This method is for referencing a unique identifier like a part number or staff id etc. kind regards David 👍
Very interesting. Paused the video and i've made this solution (the One of yours it's Better): 1) created a unique list of items to check for example in cell S27: UNIQUE(FirstTable[column]) 2) in Cell T27: N(ISERROR(XMATCH(S27;SecondTable[column]))) 3) ctrl-1 to change format in this way: [Red]"missing";;"present"
Thank you for your interest in spreading knowledge and science. My greetings to you, respected person. Please provide an Excel sheet to benefit from the wonderful content and apply it practically.❤❤
Hi! Thank you for the lesson. Can you kindly tell me is there is a way to equally distribute a value from a list to another. Ex: Suppose I have a list called A showing number of items and its weight. In the meantime I have another list called B showing the same items but more than once. What I wanted is If Apple found in list A and its value is 10 and and if the Apple found in list B the value 10 should applied in the appropriate cell in list B. But apple found twice in list B the value shoud be divided in to two and distributed to the appropriate cells in list B. List A Item Weight Apple 10 Kg Mango 6 kg Banana 8 kg Grapes 2 kg List B Weight Mango 2 Apple 5 Mango 2 Banana 4 Banana 4 Apple 5 Mango 2 Grapes 2 Whatever weight in list A should be automatically devide and place in List B. Is this possible in Excel?
@@InITLearningyes sir. I did I have to rewatch again. I have to apply that again but I got error which is below 👇 The formula you entered contains errors. If you do not wish to use a formula, insert a single quotation mark before your text.
Sir, I have a question to ask. To successfully implement this Should both list be the same in name, narration, and id? I got the first step but got an error on the second part which is the other colleague list on second spreadsheet
This just helped me a bunch to distinguish between the contents of two Spotify playlists, when I accidently deleted a third one which had my favorite songs!!!
Brilliant, I’m glad I’ve been of help to you. Regards David 👍
Loved this technique...thank you!
Thank you for watching and your nice comment. Regards David 👍
Very good explanation!
Thank you, Kind regards David 👍👍
Excellent approach and good explanation. Thank You very much.
Thank you for watching and you nice comment. Kind regards David 😀👍
Awesome 👍❤
Thank you 😀👍
That’s brilliant, mate!
Thank you for sharing and Merry Christmas!
Thank you. Merry Christmas to you as well. Regards David 😀👍
Thanks. That is great technique.
Thank you 👍😀
Very interesting video
Thank you 👍
I've always wanted to know a reliably effective method of doing this in a spreadsheet. This is super-easy to do with Microsoft Access, but its a pain in the neck to import data into Access, do my thing, and export what I need later. The more I can do in Excel, the better. KICK BUTT tutorial, good sir!
Thank you, I’m glad to have been helpful kind regards David 👍😀
Great video, and a useful illustration of the power of the filter function. One thing to be wary of, this method only checks the id field. So it won't show records that have different data recorded against the same id in Mylist and in ColleaguesList
Hi thanks for watching and commenting. It is really appreciated. Yes I agree, I would us a slightly different method if I was comparing the whole row. This method is for referencing a unique identifier like a part number or staff id etc. kind regards David 👍
Thank you Sir, can we have the data set for practicing purpose?
Of course, I will sort it out when I can over this holiday break. 👍👍🎄🎄
Hello, Practice file available to download as excel file in the video description.
Wow this is enlightening, thanks indeed 👍 🙏
You’re very welcome, kind regards David 😀👍
thanks learnt something new
You’re very welcome 👍 kind regards David 👍
Very interesting. Paused the video and i've made this solution (the One of yours it's Better):
1) created a unique list of items to check for example in cell S27: UNIQUE(FirstTable[column])
2) in Cell T27: N(ISERROR(XMATCH(S27;SecondTable[column])))
3) ctrl-1 to change format in this way:
[Red]"missing";;"present"
Hi thanks for watching and commenting, that looks interesting 👍
I hope you've shared this method with Santa Claus to make it easier to check his list and check it twice.😂😂😂
Haha I must send it to him, thanks for reminding me 😃
Thank you for your interest in spreading knowledge and science. My greetings to you, respected person. Please provide an Excel sheet to benefit from the wonderful content and apply it practically.❤❤
No problem I will put it on here soon 👍👍
Hello, Practice file available to download as excel file in the video description.
Brilliant, would you give us practice file as well
Thank you, Yes no problem I’ll try and do it by Monday 👍
Hello, Practice file available to download as excel file in the video description.
i think you could use the new "Insert Python" in the Formulas menu to do this via Pandas dataframes -Just a thought
That sounds a good thought, I might look into that. Thanks and regards David 👍
Hi! Thank you for the lesson.
Can you kindly tell me is there is a way to equally distribute a value from a list to another.
Ex: Suppose I have a list called A showing number of items and its weight.
In the meantime I have another list called B showing the same items but more than once. What I wanted is If Apple found in list A and its value is 10 and and if the Apple found in list B the value 10 should applied in the appropriate cell in list B. But apple found twice in list B the value shoud be divided in to two and distributed to the appropriate cells in list B.
List A
Item Weight
Apple 10 Kg
Mango 6 kg
Banana 8 kg
Grapes 2 kg
List B Weight
Mango 2
Apple 5
Mango 2
Banana 4
Banana 4
Apple 5
Mango 2
Grapes 2
Whatever weight in list A should be automatically devide and place in List B.
Is this possible in Excel?
Hi, I’ll have a think about it and get back to you after the Christmas holiday. Regards David 👍
@InITLearning Thank you, My seasons greatings for you have a nice holiday
You too 😀🎄🎄🎄🎄🎅🎅
Didn't work for a larger set of data 🤕
How large was your data. It should work. I’ll try this end if you let me know how large. Regards David
Wow this is very nice sir. Can i get the file for practices?
Yes no problem I’ll sort it out for you 👍
Hello, Practice file available to download as excel file in the video description.
thanks
=FILTER(G6:G13,SORT(NOT(ISNUMBER(XMATCH(G6:G13,F4:F13)))))
Thanks looks interesting 👍
Nice Job, But the formulas did not work for me.
Oh that’s a shame, what happened when you tried it? Regards David
Nice content sir.
I'm having challenges with the [Id]
How can I solve that
This is interesting
Have you created a table with the heading id?
@@InITLearningyes sir.
I did
I have to rewatch again.
I have to apply that again but I got error which is below 👇
The formula you entered contains errors.
If you do not wish to use a formula, insert a single quotation mark before your text.
Ok hope it works next time. Kind regards David
Sir, I have a question to ask.
To successfully implement this
Should both list be the same in name, narration, and id?
I got the first step but got an error on the second part which is the other colleague list on second spreadsheet
Can you send a copy of your formula