"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.
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!
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.
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.
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
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.
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
"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.
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!
An exclusive course which provides practice file with tutorial, nice effort!
Thank you very much.
Amazing no comments well done
Such a well-designed tutorial. Thank you a lot!
Amazing, I love the first tutorial, so well explained!
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.
5 years later, still teaching me new lesson.😜
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.
Very clear and helpful, Thank you.
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
Faster way to replace missing values in a column:
select column
Home - Editing - Go To Special - Blanks
Hold Key Ctrl
Enter ="99"
Ctrl + Enter
Hello, do you follow any book to organize your lessons in RUclips 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.
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
Thanks before I watch
Merci de l'avoir partagé
Why did he put 99 in the null cells ?
great work
Perfect
text dont work for me
Awesome