If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.
@mohamedselim35264 жыл бұрын
Hello All , what if i need to compare more then 2 months could you please till me how can i do it
@paulinelawrence38274 жыл бұрын
Hi This is a great tutorial - i have two sheets of data listing phone numbers for staff - each month staff join and leave and I want to find the difference between the two sheets - however the lines don't always correspond as a name in line 21 in one sheet is there in second sheet but at postion 14 (for example) is there a way I can just find the new or different values in the second sheet?
@Owanango4 жыл бұрын
This is super useful. Your English is super cool too. Thank you
@Kenny163014 жыл бұрын
@@paulinelawrence3827 I'm having the same problem
@kimchigirl2622 жыл бұрын
Add the formula to annotate the store number please.
@begashawabegaz4224 Жыл бұрын
THE 3 G man Gentle, Genuine, Genius... Respect, from Ethiopia
@ExcelAutomationByMudit4 жыл бұрын
Hi TrumpExcel, I am working in Aditya Birla Group in Dubai for past 4 years in Field of Excel Automation. And i must appreciate you for the way you are explaining to the learners. I usually do not see the basic videos but your thumbnail was too attractive to refuse. Kudos to Excel. Also in case you or any of your excel enthusiastic friend want to join for some role ill be happy to help. From Mudit Lalwani
@innovativelearning82122 жыл бұрын
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
@mrCetus2 жыл бұрын
Thanks for this great trick! Note to myself: CHAR(10) = Add Line Break in Excel Formula
@yogeshmathur32014 жыл бұрын
One of the most useful formula, I was searching to find the difference and get in one single sheet! Thanks !
@CZGrizzly4 жыл бұрын
Thanks for the video. I have one suggestion for improvement: Earlier I also used in conditional formatting the simple formula you suggest, but this has disadvantage that when you manipulate with sheet cells (eg. add/delete rows or columns), references break down and it doesn't work anymore (formatting must be restored). Much better solution is to use the formula: =INDEX(Sheet1Area,ROW(),COLUMN()) = INDEX(Sheet2Area, ROW(), COLUMN()) This will work no matter what cell manipulations you do in sheets in the future.
@chowdhurysunzidmahbub794 жыл бұрын
Please give a video of this topic.
@narutomaroc14 жыл бұрын
I faced the issue you mentioned. It would be great if you can make a tutorial.
@abhiseksingh48863 жыл бұрын
@@chowdhurysunzidmahbub79 can check this one. kzbin.info/www/bejne/a5fWnqxpqtyimZo
@abeibrahim5846Ай бұрын
Great tutorial - Q - How to get the delta between two Tables - using PQ - example: Need to know using an SW assets inventory Table, a client that has not been installed using the client current comparison Table. I must show the delta only using the Asset Name as the link field.
@stenionet2 жыл бұрын
you know how to teach. thank you very much and greetings from Brazil.
@gailjurczyk Жыл бұрын
Thank you for this clear, easy-to-follow instruction.
@CharmingHennaCreations2 жыл бұрын
You are teaching this so perfectly. This is so much easier and faster way to reconcile 2 data sets among many other methods sown in other videos . Thanks a Ton
@nealdaringer34842 жыл бұрын
No, there is way too much unnecessary information.
@varunduggal89204 жыл бұрын
The way of explanation is too good thanks for video..
@hammedcs16333 жыл бұрын
For lazy people, =if(cell1!A1cell2!A1"cell1 Value:"&cell1!A1&Char(1000)&"cell2 value:"&cell2!A1,"") Thank you for the wonderful ppt, keep up the good work.
@biswal9994 жыл бұрын
You are an awesome faculty, explain things step by step...
@FaysalEasyExcel4 жыл бұрын
from few days i am looking for this kind of video to get solution. finally found. thanks.
@tedmoy24 күн бұрын
Here's a suggestion for a video: When analyzing data between 2 data sources (ie: spreadsheets from different sources), somehow if you perform a manual CTRL find, you'll be able to find the data you're looking for, but, not if you ran a XLookUp function - probably because the formatting from individual sources are different. Show us the best practice to make both sources of data the same. I've done copying the data onto a Notepad and pasting it onto a new (3rd) separate Workbook in order to make them the same formatting for both sources. This is extremely tedious.
@JumpRopeVeteran4 жыл бұрын
This is great. This is going to save me tons of time. Thank you.
@ninabirdsong99102 жыл бұрын
You are very good in explaining..very helpful.
@devendrabain77484 жыл бұрын
Thanks you sumit, for covering such a daily occurring problem. Very useful video 👍👌👏
@trumpexcel4 жыл бұрын
Glad you found it useful!
@Zanraff5 ай бұрын
Exactly what I wanted to know how to do! Excellent explanation. Thank you. 😊
@trumpexcel5 ай бұрын
Glad you found the video helpful 🙂
@brighnquisitive62174 жыл бұрын
I thought it was going to be a different video and STILL found it useful.
@modisanjay4 жыл бұрын
Excellent , Easy to understand, Please keep it up
@jorgeespinoza3428 Жыл бұрын
This video was awesome!!! thanks!! looking forward to new tips!
@hkjony3 жыл бұрын
Undoubtedly this is extremely helpful, keep up the good work Man
@mostafakamal98033 жыл бұрын
Thank you first for your nice videos and explaining things in Excel.
@keyurshah6794 жыл бұрын
Very nicely explained 👍. Very useful for day to day working
@Sekhar_Home4 жыл бұрын
Really it is a mind blowing tutorial on excel. I was looking for it. Thanx u made my large work in easy.. more excel tutorial pls
@trumpexcel4 жыл бұрын
Glad you found it useful!
@innovativelearning82122 жыл бұрын
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
@dannycaduff63423 жыл бұрын
Thank you first for your nice videos and explaining things in Excel. In your video "How to Compare Two Excel Sheets (and find the differences)" you are talking of two identical lists and your formula only works with identical sheets. Here my question: Is there also a similar formula when the lists are not identical? (maybe with vlookup, match & index). Thank you for your answer, Danny
@pavanig2880 Жыл бұрын
Its very useful. Well explained. Thank you
@jagdishagarwal41732 жыл бұрын
Very good and very very useful..Thanks for posting..Loved it
@HellenofTroy8972 жыл бұрын
These were valuable tips. Thank you so much.
@powersystems28014 жыл бұрын
Sirji Tusi great ho this was the video which I was finding at exactly I got the same. The way of your explanation is also superb
@trumpexcel4 жыл бұрын
Thanks for the kind words :) Glad you fount it useful!
@sujithsanjeewa18904 жыл бұрын
Love to learn your tutorials Sumit. Very much useful...🙏
@trumpexcel4 жыл бұрын
Thanks Sujith... Glad you're finding the videos useful!
@Krish_Fatania Жыл бұрын
Very very useful info 😊thank you sir 😊
@andriikulishov33713 жыл бұрын
Dear Sumit, excellent video, thank you very much!
@deeparun67613 жыл бұрын
solved my whole office problem 👍👍👍
@TVSCDN4 жыл бұрын
Very good 👌 thanks
@mastixmastix Жыл бұрын
Too complicated for me. But if you have the patience to learn the possibilities of excel are truly astonishing.
@dataisfun49643 жыл бұрын
This is Golden nice one guys, I love the conditional formatting to get the difference between months.
@rosariocoutinho86903 жыл бұрын
I was looking for this formula for long time.
@ololade97034 жыл бұрын
You changed my mindset about indians
@razorpit3 жыл бұрын
The conditional formatting instruction was excellent. Exactly what I needed. Enjoyed the other information as well.
@muhammadjavediqbal67674 жыл бұрын
Asslam Alaikum Sir I am a subscriber of your channel and your excel videos are very useful....
@sharmilisen29262 жыл бұрын
Amazing 👏. I was in need of these features in my process. Thank you so much 🙂👌
@prabur4027 Жыл бұрын
Thanks a lot for your video, it's very useful and informative ☺️
@wayneedmondson10654 жыл бұрын
Hi Sumit.. thanks.. excellent video. Very useful and valuable tips. I especially like the way you set up conditional formatting to compare one version of a sheet to another (assuming same format and structure between the sheets). I can think of many uses for that in my business. I also like how you set up the formula to show the values of each different item on a third sheet.. brilliant! Thanks for sharing all of your great tips and tricks. Thumbs up for Trump Excel!
@innovativelearning82122 жыл бұрын
For complicated and high volume reconciliationI have been using Foxpro programs since as long time....
@rakeshsrivastava35984 жыл бұрын
when the tutor has an art of complicating simple things, the lesser said is better.
@imranurrahman85384 жыл бұрын
Hello Sumit. I can't express my gratitude towards you in words. Thank you so so so much. My name is Sami from Bangladesh. You are so talented, indeed. Thanks again.
@muskaanmathur74674 жыл бұрын
Very useful information I was looking for !
@alialbayati93684 жыл бұрын
Thank you Sumit for the tutorial.. Very helpful.
@trumpexcel4 жыл бұрын
Glad you found it useful!
@rajveerkhangarot57622 жыл бұрын
Very well illustrated.
@nickbell63112 жыл бұрын
I always love ❤ your videos good job men
@MushtaqQureshi7 ай бұрын
Hi Sumit -If we want column A to be displayed in the difference tab? secondly explain us a sample of multiple columns comparison/differences.
@stephenolumide58893 жыл бұрын
Great! even with my experience with excel, I haven't done anything like this before. Thank you bro
@rushikeshkadam83503 жыл бұрын
Super and useful information..Thank you!!
@anaghababu38683 жыл бұрын
I found this video very helpful. 👍
@bijoysaraf6504 жыл бұрын
Simply outstanding! Great tips. Liked & subscribed. Thank you for sharing.
@paramasivamsadagopan25814 жыл бұрын
Nicely explained
@adamt30773 жыл бұрын
This saved me so much time thank you
@trumpexcel3 жыл бұрын
Glad you found it helpful
@gunamaypal75484 жыл бұрын
Very nice. Many thanks sir
@Drkalaamarab2 жыл бұрын
Very very much useful
@StudentCompanion3 жыл бұрын
Great tutorial. Thanks
@reduasura.21743 жыл бұрын
This is very useful. Thank you!!
@vikaasb20164 жыл бұрын
Firstly, A Loud Shout out to u-This is by far the best tutorial for excel.I came back with appreciation after I did my research and learnt some unique short cuts hugely handy while at work. Also, I feel you cab be the best go-to man(teacher) for me....Sorry found you late @Sumit Bansal Sirrrrrr, My biggest pain in excel has been understanding cell referencing(not literal meaning but when using) and understanding arguments while writing formulae and formula per se....in particular the role of special characters.... Plssssssssssssssssssssssssss help ! Would be indebted for life and would spread a word far and wide !!!! I'm a in BD for last 12 years.....but want to master it..will follow u on linkedIn ,,twitter ...everywhere.👍👏👏👏👏👏👏👏👏👏👌👌👌👌👌👌👌👌😊✔✌✌✌✌✌✌
@trumpexcel4 жыл бұрын
Hello Vikus... Have you seen my free Excel course playlist. I cover cell referneces in the course (along with many other topics)
2 жыл бұрын
Thank you, you help me very much :)
@narendersingh63462 жыл бұрын
Thanks, Sir. I am not able to compare two excel sheets. Error is showing as : "You cannot use references to other worksheets or workbooks for conditional formatting criteria" Sir, please give solution.
@redsblack18423 жыл бұрын
Thank you for the video but I want to know how will you know if data in one worksheet is present in another worksheet. Since in this video your working on the difference between two cells. Example. Let's say we have the figure 10 in cell A2 and 10 is present in another cell, let's say A4 in another worksheet. How will you know that the figure is present in that cell. Looking forward to your reply. Thanks
@samantablur5924 Жыл бұрын
If you are looking for only one colum on each worksheet i think a vlookup would work
@jennyzhang80233 жыл бұрын
Extremely helpful! I wish I have learnt this earlier! Thank you so much!
@Dsamoil29054 жыл бұрын
Very useful topic. Thanks sir
@Balwan_Singh3 жыл бұрын
Brilliant tricks
@aanand1103 жыл бұрын
Very useful video...please upload video on different price comparison&analysis of report pictorial representation in charts
@georgetosounidis55454 жыл бұрын
Great tutorial again! Thanks a ton for this Sumit!!!
@yurd5633 жыл бұрын
Thank you for videolesson!
@Nihalsaviation3504 жыл бұрын
Very informative.... thank you.
@ampm2974 жыл бұрын
Great video. Thanks. It saved me a lot of time and effort!
@PandaGSXR3 жыл бұрын
This is a brilliant video. Thank you so much!
@happymm20084 жыл бұрын
Thank you so much for your tutorial! Your tips a very helpful!
@mehmetdogu3847 ай бұрын
thanks for the video.
@dataisfun49643 жыл бұрын
This is Golden nice one guys.
@debasissahoo32064 жыл бұрын
So helpful... thank you 😀
@kimberlyjohnson78384 жыл бұрын
Good video, do you have a formula that will compare an entire workbook of 12 pages to a separate worksheet with numbers and names? I need the ones that match to be highlighted.
@MrWLJ714 жыл бұрын
Superb as ever, thank you
@trumpexcel4 жыл бұрын
Thanks for commenting Bill... Glad you found the video useful!
@vr4th Жыл бұрын
Great video
@tubigonmukbangers64953 жыл бұрын
Thank you so much
@yogeshmathur32014 жыл бұрын
Please show formula clearly, a good tutorial.
@natan95743 жыл бұрын
excellent. thanks
@kimchigirl2622 жыл бұрын
What store were those changes in? What is the change and what is the store number the changes relate to? Could take this video and take the next step in relating the store number? Thanks
@pennyl49524 жыл бұрын
very helpful! thank you
@rahulsingh-yh8hk3 жыл бұрын
I am facing the issue of for highlighting the changes You cant use references to other worksheets or workbooks for Conditional formatting criteria . Please help
@demonapiccolo2 жыл бұрын
Thank you!
@Ryou234r4 жыл бұрын
This is really helpful. Thank you.
@Bld19702 жыл бұрын
very useful
@gerrijohnson89194 жыл бұрын
Great job
@massivelearn60634 жыл бұрын
Awesome, Thank you more.. Can you please make video on writing user defined formulas under conditional formatting option... Thank you!!
@Jen-tq2bt4 жыл бұрын
This is so useful. Thanks!
@ramamohanpathapati76943 жыл бұрын
Excellent
@barryk79494 жыл бұрын
Very helpful! Thank you.
@mirzaataullahbaig413 Жыл бұрын
Great man
@skyrock22664 жыл бұрын
a scenario where store is in a different order or may not be in incremental order then how do we compare two spread sheets considering store as the primary key.