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