How To Compare Excel Files and Find Differences

How to compare two Excel sheets and find differences between them.
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.com/xvexzhqfma
In this video I'm going to show you how to compare two separate excel files and find the differences between them. We'll compare for both separate Excel files and separate worksheet tabs in the same Excel file as well. First, we'll do this using the COUNTIF function, where every time there's a 0 as a result, there's a difference betwen the two worksheets. Second, we'll do this by setting up a new rule with conditional formatting so the different values get highlighted. Thirdly, we'll do this with a complex IF formula so we can see the 2 different answers when they're not matching. Finally, as a bonus, we'll use the spreadsheet compare tool to find the differences.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinciples?hl=en
🤳 TikTok - www.tiktok.com/@career_principles
🧑‍💻 LinkedIn - www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Correct View Setup
1:20​ - Beginner Solution
2:44​ - Intermediate Solution
4:11​ - Advanced Solution
7:44​ - Comparing Different Excel Files
9:36​ - Bonus: Spreadsheet Compare

[@KenjiExplains]

✅Take our for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance

[@Masoom36]

So glad I stayed until the end for the Spreadsheet Compare!!

[@KenjiExplains]

Awesome :)

[@Diop90]

God bless you. We definitely need more people like you on this planet 🙌🏽

[@KenjiExplains]

Haha doing some Excel videos nothing that special XD. Thank you for your kind comment :)

[@vipulagarwal7320]

That 'Spreadsheet Compare' bonus feature was DOPE!!!! Thanks Kenji

[@tdc96]

The Spreadsheet Compare App!! Thank you so much for showing that! I have been looking for something like that for a year and had no idea it was already on my system!!! Awesome!!

[@domy9187]

I've been using ms excel for a while however did not know the 'spreadsheet compare' existed. Thank you!

[@assanelo8768]

Love the Spreadsheet Compare! It was like finding a hidden treasure!

[@KenjiExplains]

Glad it was helpful!

[@sheewieful]

Mindblown by the bonus feature🤯Thanks Kenji!

[@KenjiExplains]

That's great to hear thanks for watching!!

[@debbielaubscher4983]

Brilliant! Thank you Kenji.

[@Saadi_Lyfe]

Loved it... Thank you so much.. I learn so much from you ❤❤

[@camlex6310]

Super helpful feature!!

[@user-nv6hp5bm2d]

I appreciate your time and effort for that i thank you from algeria me and my team

[@KenjiExplains]

My pleasure, thank you for watching :)

[@xcelurself]

Thank you for sharing these tips. I also love comparing tables with power query and play with the different types of joins.

[@xcelurself]

Either to get unique values in each table, duplicates or else to get the differences

[@KenjiExplains]

Interesting, thank you for sharing :)

[@mmartinez9883]

Where can I learn how to do this? This would help me with my job

[@ActiveLearningforAll]

Thank you!

[@motopelamohapi4152]

Thank you, Kenji.

[@KenjiExplains]

Thanks for watching :)

[@alexrosen8762]

Very useful tutorial 👌🙏👌

[@KenjiExplains]

Thank you! Cheers!

[@rimmasiefert1321]

Thank you❤

[@KenjiExplains]

You're welcome 😊

[@mohdward9505]

Awesome 👍

[@KenjiExplains]

Thank you!

[@UtkarshKumar-mp2ls]

Great kenji

[@KenjiExplains]

Thank you!

[@willzinner8813]

thanks you sir

[@KenjiExplains]

Thanks for watching

[@ulchhunly8435]

Can you make a video how to copy and paste data without go to hiden row ?

[@ksumar]

Love the conditional formatting one as I didn't know how you would apply that. I normally use = TabA (cellRef) =TabB on cell to return True /False!

[@KenjiExplains]

Awesome! Thank you for watching :)

[@erikguzik8204]

What is the APP (add in) for the spread sheet compare? not in my version of windows 11? Thanks much

[@Mixolydian74]

Do both files need to have the same column order to use spreadsheet compare?

[@sallyho146]

Thank you Kenji! I’ve been using if function to compare😊. Is the spreadsheet compare a part of excel I can download or search in my computer? How much are the courses? Can you help me fix my graph? I am using clustered charts with primary axis and secondary axis to stack until sold and unit price for 3 types of products for 4 locations. One of the products secondary axis number ($7.5M) is bigger than primary axis number (7 sold units). So in the chart, the 2nd axis covering/over lapping the primary axis. How do I fix it? I added invisible value column and useing max formula. Added it to both primary and secondary axis. Still doesn’t work. Please help

[@passiveincomeexplorer3396]

I was expecting to see a scenario where rows were not just different but also rearranged. so i was thinking of concatenating all columns in a row then lookup from both sides

[@pietrocantuccini5584]

Which is the first version 'spreadsheet compare' is available??

[@InManIsGod]

I can't find the compare spreadsheet tool. How can i get it ?

[@asisatan3731]

please share all free excel thanks,

[@ThomasBuehlmann]

the best way to do this is to create a hashsum across columns in V1 and figure out if it is different to the "corresponding" record in V2.

[@user-md4zt6fw8y]

I don't have that spreadsheet compare tool. where to download that?

[@lusciousvisualfeasts]

Hii Kenji can make series on CRM or anyone can tell me who can teach CRM like Kenji i need urgent help 😢

[@cecilm3720]

A simple VBA comparing cells is much easier.

[@manod7100]

Hi sir

[@waynez8136]

Cant find the "Spreadsheet Compare" app

[@unlocking_potential123]

Definitely gonna go with the "2nd" and the "last" method. 😅😂

[@usmanmohammed5269]

how can i have cracked version of excel 2021?

[@NITINPATEL-rc1tt]

I have better way to check and reconcile both sheet diff

[@pietrocantuccini5584]

Which is????

[@geekatari4391]

I would have used Power Query. That last method was definitely hidden from me.

[@KenjiExplains]

Thanks for letting me know!

[@rmmm329]

None of these are the best way to compare 2 versions of a table

[@forestdean8064]

It's almost like there are multiple ways to do things