How to Compare Two Excel Sheets (and find the differences)
In this video, I will show you a couple of methods to compare two Excel sheets for differences or compare two Excel files.
There are some in-built features in Excel, such as View side-by-side and New Window that make the comparison of sheets easy. It allows you to open each sheet as a separate file and view these side-by-side.
This is a good method when you want to manually compare the sheets.
In case you have huge datasets, you can also use the conditional formatting method, or the formula method covered in this video.
----------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:27 Compare Two Sheets in Different Excel Workbooks
03:48 Compare Two Excel Sheets in the Same Workbook
07:14 Compare Two Sheets in Highlight Differences
11:03 Compare Sheets in Fetch the Differences
----------------------------------------------------------------------------------------------------------------------
Subscribe to this KZread channel to get updates on Excel Tips and Excel Tutorials videos - / trumpexcel
This KZread channel is managed by Sumit Bansal (who also runs the TrumpExcel website).
This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.
You can find a lot of useful Excel resources on the following site: trumpexcel.com/
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzread.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 276
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.
@mohamedselim3526
4 жыл бұрын
Hello All , what if i need to compare more then 2 months could you please till me how can i do it
@paulinelawrence3827
4 жыл бұрын
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?
@Owanango
4 жыл бұрын
This is super useful. Your English is super cool too. Thank you
@Kenny16301
4 жыл бұрын
@@paulinelawrence3827 I'm having the same problem
@kimchigirl262
2 жыл бұрын
Add the formula to annotate the store number please.
THE 3 G man Gentle, Genuine, Genius... Respect, from Ethiopia
This is great. This is going to save me tons of time. Thank you.
One of the most useful formula, I was searching to find the difference and get in one single sheet! Thanks !
from few days i am looking for this kind of video to get solution. finally found. thanks.
Thank you for this clear, easy-to-follow instruction.
I thought it was going to be a different video and STILL found it useful.
Great tutorial again! Thanks a ton for this Sumit!!!
This is Golden nice one guys, I love the conditional formatting to get the difference between months.
Extremely helpful! I wish I have learnt this earlier! Thank you so much!
Simply outstanding! Great tips. Liked & subscribed. Thank you for sharing.
Amazing 👏. I was in need of these features in my process. Thank you so much 🙂👌
You are an awesome faculty, explain things step by step...
Thank you so much for your tutorial! Your tips a very helpful!
Undoubtedly this is extremely helpful, keep up the good work Man
you know how to teach. thank you very much and greetings from Brazil.
This is a brilliant video. Thank you so much!
Great video. Thanks. It saved me a lot of time and effort!
Very well illustrated.
These were valuable tips. Thank you so much.
Thanks you sumit, for covering such a daily occurring problem. Very useful video 👍👌👏
@trumpexcel
4 жыл бұрын
Glad you found it useful!
Thanks for this great trick! Note to myself: CHAR(10) = Add Line Break in Excel Formula
The way of explanation is too good thanks for video..
The conditional formatting instruction was excellent. Exactly what I needed. Enjoyed the other information as well.
Very helpful! Thank you.
Excellent , Easy to understand, Please keep it up
Very useful information I was looking for !
This video was awesome!!! thanks!! looking forward to new tips!
Very nicely explained 👍. Very useful for day to day working
Thank you Sumit for the tutorial.. Very helpful.
@trumpexcel
4 жыл бұрын
Glad you found it useful!
Just Awesome, loved this.
Love to learn your tutorials Sumit. Very much useful...🙏
@trumpexcel
4 жыл бұрын
Thanks Sujith... Glad you're finding the videos useful!
You are very good in explaining..very helpful.
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.
Its very useful. Well explained. Thank you
Great tips! Thanks!
Very informative.... thank you.
I was looking for this formula for long time.
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
@innovativelearning8212
2 жыл бұрын
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
Super and useful information..Thank you!!
Great tutorial. Thanks
Exactly what I wanted to know how to do! Excellent explanation. Thank you. 😊
@trumpexcel
3 ай бұрын
Glad you found the video helpful 🙂
This is really helpful. Thank you.
Very good and very very useful..Thanks for posting..Loved it
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
@trumpexcel
4 жыл бұрын
Glad you found it useful!
This is so useful. Thanks!
This is very useful. Thank you!!
Thanks a lot for your video, it's very useful and informative ☺️
Thank you for videolesson!
Thank you first for your nice videos and explaining things in Excel.
very helpful! thank you
Very useful topic. Thanks sir
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
@trumpexcel
3 жыл бұрын
Thanks for the kind words :) Glad you fount it useful!
Very very useful info 😊thank you sir 😊
Dear Sumit, excellent video, thank you very much!
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.
So helpful... thank you 😀
I found this video very helpful. 👍
solved my whole office problem 👍👍👍
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!
@innovativelearning8212
2 жыл бұрын
For complicated and high volume reconciliationI have been using Foxpro programs since as long time....
Very good 👌 thanks
Awesome, Thank you more.. Can you please make video on writing user defined formulas under conditional formatting option... Thank you!!
This saved me so much time thank you
@trumpexcel
3 жыл бұрын
Glad you found it helpful
Nicely explained
Thank you, you help me very much :)
Superb as ever, thank you
@trumpexcel
4 жыл бұрын
Thanks for commenting Bill... Glad you found the video useful!
Thank you, Sumit!
@mangam6369
4 жыл бұрын
Thanks I’m sumit as well
Very nice. Many thanks sir
U r amazing. Thanks a lot.
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.
Super useful! Thanks :-)
@trumpexcel
4 жыл бұрын
Glad you found it useful!
Thank you!
Great job
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
@nealdaringer3484
2 жыл бұрын
No, there is way too much unnecessary information.
I always love ❤ your videos good job men
thanks for the video.
Great! even with my experience with excel, I haven't done anything like this before. Thank you bro
Very useful video...please upload video on different price comparison&analysis of report pictorial representation in charts
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
Very very much useful
thank u sir
excellent. thanks
Asslam Alaikum Sir I am a subscriber of your channel and your excel videos are very useful....
Awesome 👍👍
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
Very good video! Could you just tell me what is purpose of "column sign :" when you used it? what is actual usage of it in the formula?
Thanks for this video. Very good explanation. I have a question... let's say we have 2 sheets and want to highlight the values present in 1st sheet but not in 2nd and. vice versa in different color irrespective to exact row for ex. sheet1-A10 value might be there in sheet2-A15. can we do this kind of comparison?
Thank you so much
This is Golden nice one guys.
The best I've seen thx! I'm subscribing.
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.👍👏👏👏👏👏👏👏👏👏👌👌👌👌👌👌👌👌😊✔✌✌✌✌✌✌
@trumpexcel
4 жыл бұрын
Hello Vikus... Have you seen my free Excel course playlist. I cover cell referneces in the course (along with many other topics)
very useful
Great man
Tank you Sir!
Great video
Brilliant tricks
Excellent
Thanks a lot bro good job (Y)
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.
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.
@chowdhurysunzidmahbub79
4 жыл бұрын
Please give a video of this topic.
@narutomaroc1
4 жыл бұрын
I faced the issue you mentioned. It would be great if you can make a tutorial.
@abhiseksingh4886
3 жыл бұрын
@@chowdhurysunzidmahbub79 can check this one. kzread.info/dash/bejne/Z5qnz9tspdrVk5s.html