The reason why I have told date & time are sensitive things in excel at the beginning because of this kind of scenario in excel. Even though both are different, the result is still TRUE, i.e., both are the same. One interesting fact about this example is row number 7 in this row first date is written as “2,” but the second date is written as 43767. So, wherever data is matched, we have got the result as TRUE, and wherever data is not matched, we have got the result as FALSE. Drag the formula to the following columns as well to get the result.We have the same date in both columns, so we got TRUE as a result. Now in cell C2, apply the formula as “=A2=B2”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |