# Learn How to Find Longest String With Criteria in Microsoft Excel

Written by | 0 Comments | 263 Views

In this article, you will learn how to evaluate things based on the LOOKUP function in Microsoft Excel using a single/combination(s) of functions. You will also know to Find Longest String With Criteria and see the generic formula.

Learn How to Find Longest String With Criteria in Microsoft Excel

The main purpose of this formula is to find the longest string in a range with criteria. Here we will learn how to find the longest string with criteria in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the INDEX, LEN, MAX, and MATCH function you can able to find the longest string in a range with criteria. So, with the help of this formula, you can able to find the longest with criteria column in the given data range in the workbook in Microsoft Excel.

General Formula to Find Longest String With Criteria

=INDEX(rng1,MATCH(MAX(LEN(rng1)*(rng2=criteria)),LEN(rng1)*(rng2=criteria),0))

The Explanation to Find Longest String With Criteria

So we know that with the help of the given formula above you can able to find the longest string in a range with criteria. Here we will learn how to find the longest string with criteria in the given data range in the workbook in Microsoft Excel. As we know that at the core of this formula there is the MATCH function. It is used to locate the position of the longest string using supplied criteria. After LEN and MAX run, the MATCH function then returns the position. So now you have learned how to find the largest string with criteria in the given data range in the workbook in Microsoft Excel.