hi kenji, thanks a lot. ur explaining is crystal clear n brilliant delivered 👏👏 btw do u have any tricks to process data more than 800k rows? i had many data that have to process with many formula n sheets. but its usually run slow n not responding.. 😢
Thanks a lot for your video! I have one question, I follow your Table Trick to link data from Table Worksheet A to Worksheet B. But when I close Workshet A, the data in Worksheet B show #Ref, and sometime it doesn't update data. Please help me more on it? Thanks.
Thank you for your video. Just quick question. Does it work also between excel files, that are synchronized on Google drive? I have some files on my PC in the Google Drive folder. And it seems that they are not updated, unless I open each file separately.
Is it possible to automate this across multiple sheets to transfer to a single sheet? Background. Have a template sheet that is copied over to be used for multiple classes throughout the year.
Bro You just give me a massive data analysis Idea. Now I'm going to find - "Combine dirty Data from another multiple Excel workbooks by using Power Quarry in Pivot Table format". if you find the solution. plz let me know.
Have used linking data between files and then others would either rename the original file or move its location thereby breaking the link between the files
How to ignore empty cell while checking grater than value , and how to write code for check c2 coloum is some condition and d2 is Some function if both true we should get our condition
Hey I only add one add per video which is 1 minute long for videos ranging from 10-20 minutes I think it's a reasonable ratio. You get to watch it for free, download the file and even skip through the video if you're not interested.
👉 Take our Data Analyst Program: www.careerprinciples.com/career-track/the-data-analyst-program
Can you slove my issue in live
KENJI HELPING ME ALOT..... THANKS KENJI... YOU ARE IN FACT GOLD MEDALIST IN EXCEL OLYMPICS...
when Kenji post you watch and bookmark
True story. I have a whole file of his videos.
thanks as always
Thank you!!
Thanks Kenji,
Awesome tutorial as always.
Could you please make one video for large CSV files data cleaning.
table method is so easy & interesting
thanks Kenji..straighforward and Ive learned a lot
hi kenji, thanks a lot. ur explaining is crystal clear n brilliant delivered 👏👏
btw do u have any tricks to process data more than 800k rows?
i had many data that have to process with many formula n sheets. but its usually run slow n not responding.. 😢
As always new learning from video's thanks 🙏🏻
7:15, kenji can we use xlookup for the same? Like we used it before in your previous video of xlookup
Hi Kenji thanks to your tricks. It is Very Useful.
I love your super professional videos! thank you! which tools do you use for recording and editing?
Keep up the smile always...❤ Thanks a lot for all these knowledge sharing Sir...❤
Thanks a lot for your video!
I have one question, I follow your Table Trick to link data from Table Worksheet A to Worksheet B. But when I close Workshet A, the data in Worksheet B show #Ref, and sometime it doesn't update data. Please help me more on it? Thanks.
Give me three excel files . I would like to write a project.
You're really amazing.
From Africa
What version of Excell software you're using in this video? thanks a lot.
Thank you for your video.
Just quick question. Does it work also between excel files, that are synchronized on Google drive? I have some files on my PC in the Google Drive folder. And it seems that they are not updated, unless I open each file separately.
How to maintain the formatting? While replicating the data from Sheet1 to Sheet2 (Without using tables)
Is it possible to open SPSS data in excel?
Really helpful technique!!
Can this work in two workbooks in different computers after sharing the document? It didn't work on my end though
Is it possible to automate this across multiple sheets to transfer to a single sheet?
Background. Have a template sheet that is copied over to be used for multiple classes throughout the year.
Why not use ifblank instead
Kenji 🤝🏿
What formula shold we use if we want to repeat the same word multiple times but vertically
Very useful 🎉
Bro You just give me a massive data analysis Idea.
Now I'm going to find - "Combine dirty Data from another multiple Excel workbooks by using Power Quarry in Pivot Table format".
if you find the solution. plz let me know.
Nice one.
A simple copy paste works too
*SEARCH*
*DONALD NATHAN SCOTT.*
awesome
must all the linked files be in the same folder? and if i need to move the folder to another location (e.g. D:\ to E:\), will it still work?
With the formulas it should be fine. With power query you would need to change the path in the source step.
Have used linking data between files and then others would either rename the original file or move its location thereby breaking the link between the files
How to ignore empty cell while checking grater than value , and how to write code for check c2 coloum is some condition and d2 is Some function if both true we should get our condition
chatgpt is free
where is = data formula available is in 365excel
These days I am seeing lot of ads!
Hey I only add one add per video which is 1 minute long for videos ranging from 10-20 minutes I think it's a reasonable ratio. You get to watch it for free, download the file and even skip through the video if you're not interested.
Dimona
🇸🇴🇸🇴👋
Hello! Thanks for watching :)