![]() ![]() Since it is not possible that we will always have structured data in our excel as per our needs and whims therefore we can either split the data or content of one cell into individual cells or you can combine the individual cells. Second important function to learn in Data Analytics in Excel is Concatenate. This function can return any kind of data such as string, numerical or dates, Words etc. ![]() And if you omit to write any of these then it will take True by default and you will get an approximate match. If you will enter the True then you will get an approximate value and if you will enter the False then you will get an exact value. Index number is the column number from which the matching value shall be returned.Īpproximate match is to find the match. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |