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