I like the detailed analysis of the step by step process of what to focus on that needs to be taken care of. One group of items at a time. Bite sized portion coverage is good!
"I don't have those rain man types of minds where you give me a date and I tell you what day the week it is, so I'm just going to use excel to show me." I'm dead. Awesome video, as well as part 2.
Why is it when I do the =TEXT(B2,"dddd") it doesn't come up with the day of the week? Instead it just comes up with the same thing that is in cell B2.. Thanks SO much for this.
I used your file. In the last example for days^some convert to the day, some remain to the same value as in the b column. Why: different excel versions?
I just figured it out -- it's because the file is using the American date format of m/d/y instead of d/m/y -- excel can't do anything with months like 13 or 20.
This is the good helping video thank you for tutorial. I work on Excel I work on data which takes very long time can you tell me any formula which can match two different rows where host names are to validate whether the hostname mentioned in row D "Alert in server LUM1234NG at " is similar to row I "Lum124g" or same host name mentioned in uppercase"LUM124G" I hack to scrub the excel file which has two hundred thousand columnsand same kind of data mismatch is there and I am not able to find the right formula to do validation
Thanks, the video is well explained, though when i was converting data some remained as the date in the original format while some change to text. how do I handle such situations
Why is it when I do the =TEXT(B2,"dddd") it doesn't come up with the day of the week? Instead it just comes up with the same thing that is in cell B2.. Thanks SO much for this.
I like the detailed analysis of the step by step process of what to focus on that needs to be taken care of. One group of items at a time. Bite sized portion coverage is good!
"I don't have those rain man types of minds where you give me a date and I tell you what day the week it is, so I'm just going to use excel to show me."
I'm dead. Awesome video, as well as part 2.
Amazing no comments well done
An exclusive course which provides practice file with tutorial, nice effort!
Thank you very much.
Such a well-designed tutorial. Thank you a lot!
Why is it when I do the =TEXT(B2,"dddd") it doesn't come up with the day of the week? Instead it just comes up with the same thing that is in cell B2.. Thanks SO much for this.
Amazing, I love the first tutorial, so well explained!
5 years later, still teaching me new lesson.😜
Hello, do you follow any book to organize your lessons in UA-cam or in your website?
I used your file. In the last example for days^some convert to the day, some remain to the same value as in the b column. Why: different excel versions?
I just figured it out -- it's because the file is using the American date format of m/d/y instead of d/m/y -- excel can't do anything with months like 13 or 20.
This is the good helping video thank you for tutorial. I work on Excel I work on data which takes very long time can you tell me any formula which can match two different rows where host names are to validate whether the hostname mentioned in row D "Alert in server LUM1234NG at " is similar to row I "Lum124g" or same host name mentioned in uppercase"LUM124G" I hack to scrub the excel file which has two hundred thousand columnsand same kind of data mismatch is there and I am not able to find the right formula to do validation
Thanks, the video is well explained, though when i was converting data some remained as the date in the original format while some change to text. how do I handle such situations
Very clear and helpful, Thank you.
Faster way to replace missing values in a column:
select column
Home - Editing - Go To Special - Blanks
Hold Key Ctrl
Enter ="99"
Ctrl + Enter
Why did he put 99 in the null cells ?
Merci de l'avoir partagé
text dont work for me
Thanks before I watch
great work
Perfect
Awesome
Why is it when I do the =TEXT(B2,"dddd") it doesn't come up with the day of the week? Instead it just comes up with the same thing that is in cell B2.. Thanks SO much for this.