![]() If no match was found, a “#N/A” error is returned. And, based on that it will give back a number to your spreadsheet. It does just what its name implies: it matches a value against a set of values. The MATCH function is a built-in function in Excel. Ok, let’s break down that formula Meet MATCH See? Now you’ve detected each duplicate value and can easily see them in the list. Now, you should be looking at an image like the one above.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |