I was looking for a formula in Excel to search in different ranges of parts of text meeting another criterion. So, basically, it's a COUNTIFS. When trying to use the formula, which works perfectly, I am faced with a problem when looking for strings containing more than 255 characters.
Here is an example of the formula I use (COUNTIFS in English).
= CONTAR.SI.CONJUNTO (Sheet! $ D $ 2: $ D $ 10; "First criterion"; Sheet! $ H $ 2: $ H $ 1000; "second criterion")
Since the first string is longer than 255 characters, the result is always 0 element found.
Has anyone ever faced this problem? Any idea of how to solve it would be appreciated. Thank you so much!