✅Take our for Business & Finance Course: www.careerprinciples.com/courses/excel-for-business-finance
@vipulagarwal7320
2 ай бұрын
That 'Spreadsheet Compare' bonus feature was DOPE!!!! Thanks Kenji
@Diop90
3 ай бұрын
God bless you. We definitely need more people like you on this planet 🙌🏽
@KenjiExplains
3 ай бұрын
Haha doing some Excel videos nothing that special XD. Thank you for your kind comment :)
@domy9187
2 ай бұрын
I've been using ms excel for a while however did not know the 'spreadsheet compare' existed. Thank you!
@tdc96
2 ай бұрын
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!!
@Masoom36
2 ай бұрын
So glad I stayed until the end for the Spreadsheet Compare!!
@KenjiExplains
2 ай бұрын
Awesome :)
@assanelo8768
2 ай бұрын
Love the Spreadsheet Compare! It was like finding a hidden treasure!
@KenjiExplains
2 ай бұрын
Glad it was helpful!
@mariahafeez6189
23 күн бұрын
After searching google and you tube, finally I landed to the right one. Thanks for sharing, keep helping :)
@sheewieful
2 ай бұрын
Mindblown by the bonus feature🤯Thanks Kenji!
@KenjiExplains
2 ай бұрын
That's great to hear thanks for watching!!
@xcelurself
3 ай бұрын
Thank you for sharing these tips. I also love comparing tables with power query and play with the different types of joins.
@xcelurself
3 ай бұрын
Either to get unique values in each table, duplicates or else to get the differences
@KenjiExplains
3 ай бұрын
Interesting, thank you for sharing :)
@mmartinez9883
2 ай бұрын
Where can I learn how to do this? This would help me with my job
@jamessabadi1302
Ай бұрын
Spreadsheet compare. That was gold.
@extraktAI
4 күн бұрын
Awesome video Kenji!
@user-nv6hp5bm2d
3 ай бұрын
I appreciate your time and effort for that i thank you from algeria me and my team
@KenjiExplains
3 ай бұрын
My pleasure, thank you for watching :)
@ksumar
2 ай бұрын
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
2 ай бұрын
Awesome! Thank you for watching :)
@ddp2049
15 күн бұрын
Hello The spreadsheet comparison is only available in Microsoft 365 enterprise, not the home addition
@zelieusnamirian3519
5 күн бұрын
but in this case, sheets and rows of order number are identical, what if the order numbers are jumbled, then these methods would not work?
@Saadi_Lyfe
2 ай бұрын
Loved it... Thank you so much.. I learn so much from you ❤❤
@williamarthur4801
Ай бұрын
if you just want to see the rows that contain a difference; = FILTER( 'v1'!B2:E19, BYROW( --('v1'!B2:E19 'v2'!B2:E19), LAMBDA(x, SUM(x))))
@YellowbuIb
27 күн бұрын
where do I download spreadsheet compare if I don't find it in my desktop. I'm running windows 11 with office 365.
@debbielaubscher4983
2 ай бұрын
Brilliant! Thank you Kenji.
@tedmoy
Ай бұрын
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.
@erikguzik8204
3 ай бұрын
What is the APP (add in) for the spread sheet compare? not in my version of windows 11? Thanks much
@ulchhunly8435
2 ай бұрын
Can you make a video how to copy and paste data without go to hiden row ?
@sallyho146
3 ай бұрын
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
@camlex6310
2 ай бұрын
Super helpful feature!!
@pietrocantuccini5584
2 ай бұрын
Which is the first version 'spreadsheet compare' is available??
@Tjej-k2p
Ай бұрын
But what if I don't have any number on my excel sheet? I have alphanumeric characters, so it didn't work :(
@Mixolydian74
3 ай бұрын
Do both files need to have the same column order to use spreadsheet compare?
@InManIsGod
2 ай бұрын
I can't find the compare spreadsheet tool. How can i get it ?
@user-md4zt6fw8y
2 ай бұрын
I don't have that spreadsheet compare tool. where to download that?
@motopelamohapi4152
2 ай бұрын
Thank you, Kenji.
@KenjiExplains
2 ай бұрын
Thanks for watching :)
@freeshare-2all
2 ай бұрын
F4 key is not okay. How should do?
@UtkarshKumar-mp2ls
3 ай бұрын
Great kenji
@KenjiExplains
3 ай бұрын
Thank you!
@alexrosen8762
2 ай бұрын
Very useful tutorial 👌🙏👌
@KenjiExplains
2 ай бұрын
Thank you! Cheers!
@passiveincomeexplorer3396
2 ай бұрын
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
@ThomasBuehlmann
2 ай бұрын
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.
@rimmasiefert1321
3 ай бұрын
Thank you❤
@KenjiExplains
3 ай бұрын
You're welcome 😊
@lusciousvisualfeasts
2 ай бұрын
Hii Kenji can make series on CRM or anyone can tell me who can teach CRM like Kenji i need urgent help 😢
@asisatan3731
3 ай бұрын
please share all free excel thanks,
@freeshare-2all
2 ай бұрын
Thanks you so much
@ActiveLearningforAll
2 ай бұрын
Thank you!
@mohdward9505
3 ай бұрын
Awesome 👍
@KenjiExplains
3 ай бұрын
Thank you!
@willzinner8813
3 ай бұрын
thanks you sir
@KenjiExplains
3 ай бұрын
Thanks for watching
@unlocking_potential123
2 ай бұрын
Definitely gonna go with the "2nd" and the "last" method. 😅😂
@waynez8136
3 ай бұрын
Cant find the "Spreadsheet Compare" app
@usmanmohammed5269
2 ай бұрын
how can i have cracked version of excel 2021?
@cecilm3720
2 ай бұрын
A simple VBA comparing cells is much easier.
@manod7100
2 ай бұрын
Hi sir
@NITINPATEL-rc1tt
2 ай бұрын
I have better way to check and reconcile both sheet diff
@pietrocantuccini5584
2 ай бұрын
Which is????
@geekatari4391
2 ай бұрын
I would have used Power Query. That last method was definitely hidden from me.
@KenjiExplains
2 ай бұрын
Thanks for letting me know!
@rmmm329
3 ай бұрын
None of these are the best way to compare 2 versions of a table
@forestdean8064
2 ай бұрын
It's almost like there are multiple ways to do things
@pirate185
Ай бұрын
So where are your best ways 🚮
@rmmm329
Ай бұрын
@@pirate185 yeah I’ll definitely tell you now 😂 i used to tie out 250,000 row tables when migrating to new ERP systems, and you don’t do it using conditional formatting or if statements
Пікірлер: 75