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

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

@KenjiExplains

20 күн бұрын

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

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

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

@KenjiExplains

12 күн бұрын

Awesome :)

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

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!!

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

@KenjiExplains

19 күн бұрын

Glad it was helpful!

Mindblown by the bonus feature🤯Thanks Kenji!

@KenjiExplains

19 күн бұрын

That's great to hear thanks for watching!!

Brilliant! Thank you Kenji.

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

Super helpful feature!!

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

@KenjiExplains

20 күн бұрын

My pleasure, thank you for watching :)

Thank you!

Thank you, Kenji.

@KenjiExplains

19 күн бұрын

Thanks for watching :)

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

@xcelurself

20 күн бұрын

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

@KenjiExplains

20 күн бұрын

Interesting, thank you for sharing :)

@mmartinez9883

17 күн бұрын

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

Very useful tutorial 👌🙏👌

@KenjiExplains

19 күн бұрын

Thank you! Cheers!

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

19 күн бұрын

Awesome! Thank you for watching :)

Thank you❤

@KenjiExplains

20 күн бұрын

You're welcome 😊

Great kenji

@KenjiExplains

20 күн бұрын

Thank you!

Awesome 👍

@KenjiExplains

20 күн бұрын

Thank you!

thanks you sir

@KenjiExplains

20 күн бұрын

Thanks for watching

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

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

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.

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

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

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

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

A simple VBA comparing cells is much easier.

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

please share all free excel thanks,

Hi sir

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

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

Cant find the "Spreadsheet Compare" app

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

@KenjiExplains

19 күн бұрын

Thanks for letting me know!

how can i have cracked version of excel 2021?

I have better way to check and reconcile both sheet diff

@pietrocantuccini5584

11 күн бұрын

Which is????

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

@forestdean8064

13 күн бұрын

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