This is great! I need example 3 but not comparing cost, I just need to return what is found in the columns with what is is different in the 3rd column i.e. same employee ID and amount but different coding. Help!
Thank you, Sir, for your valuable information; I have questions. I have 2 Excel data sheets that I need to compare, and after the comparison, I need to copy the correct values from one data sheet to another and download it. Could you please help me with that? Thank you.
nice one but for beginner power query users like myself, you may want to slow down a bit and more importantly, not skip important steps. Just a thought. Thanks for the tutorial
I really needed this AND I enjoyed watching....however....please slow down. It's hard to follow. I don't know if you're shooting for a particular time limit but it's a struggle to follow your steps. Thank you for the upload.
Wow. I had no idea all this stuff was possible. I thought I'd need some whacky formula to get these results but this seems more elegant. The only issue I'm facing is that since one of the data sources is another excel file on someone else's sharepoint... well, I don't know if it's because of this but the issue (inconvenience, really) is that it doesn't live update. I need to hit Data > Refresh All to get it to update. I've made a couple formulas that warn me to do so if the counts don't match up but live updating would be nicer. Anyway. Thanks so much for the quick and easy guide! It was a perfect solution for the problem I was trying to get past.
Amazing! Love the clarity and speed of the instructions. Thanks a lot!
Great video! Excellent!
Thank you very much!
Providing the initial data as a download would really help.
This is great! I need example 3 but not comparing cost, I just need to return what is found in the columns with what is is different in the 3rd column i.e. same employee ID and amount but different coding. Help!
very nice
Thanks
Thank you, Sir, for your valuable information; I have questions. I have 2 Excel data sheets that I need to compare, and after the comparison, I need to copy the correct values from one data sheet to another and download it. Could you please help me with that?
Thank you.
Please provide link to download spreadsheet to follow along.
nice one but for beginner power query users like myself, you may want to slow down a bit and more importantly, not skip important steps. Just a thought. Thanks for the tutorial
Noted
I really needed this AND I enjoyed watching....however....please slow down. It's hard to follow. I don't know if you're shooting for a particular time limit but it's a struggle to follow your steps. Thank you for the upload.
Tip: Click the "Settings" cog at bottom of video frame, Click "Playback Speed", Choose a slower speed 👍
It would be great, if provided the practice file...
Wow. I had no idea all this stuff was possible. I thought I'd need some whacky formula to get these results but this seems more elegant. The only issue I'm facing is that since one of the data sources is another excel file on someone else's sharepoint... well, I don't know if it's because of this but the issue (inconvenience, really) is that it doesn't live update. I need to hit Data > Refresh All to get it to update. I've made a couple formulas that warn me to do so if the counts don't match up but live updating would be nicer.
Anyway. Thanks so much for the quick and easy guide! It was a perfect solution for the problem I was trying to get past.
how can you match the positive and negative amounts in excel power query
Great video but I think if you could speak a little slower that would be great