Microsoft Excel

Learn How to Find Longest String With Criteria in Microsoft Excel

Learn How to Find the 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 functions, 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 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 the Longest String With Criteria

Learn How to Find Longest String With Criteria in Microsoft Excel

 

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.