Sometimes you need to point out the position of the value that does not match the given criteria. In this case, what would you do? Here, we come up with the simple formula used to match the occurrence that does not begin with a specific value in Excel. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- Use the below formula to match the first value that does not begin with certain criteria given.
Syntax Explanations:
- MATCH – The MATCH functionin Excel is used to locate the position of a lookup value in a row, column, or table.
- FALSE – In Excel, the FALSE function helps to return the logical value FALSE.
- Data – It is the input range.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Let’s consider the below example image.
- Here, we will give the input values in Column B and Column C.
- Then, enter the given formula in the formula bar section.
- Press CTRL + SHIFT + ENTER Keys.
- Finally, we get the result in the selected cell.
Verdict:
From this short tutorial, we have described the simple formula used to match the occurrence that does not begin with a specific value in Excel. Hope you like it. Please state your query in the below comment box. To learn more, check out Geek Excel!! *and Excel Formulas *!!
Top comments (0)