"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.
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.
