Hi,
I would like to ask you for help with a MINIFS formula where one of the conditions is the length of words in the criteria range.
e.g I need to calculate the minimum value in range A2:E5 where one of the criteria is that the length of text in range A1:E1 is 4 . In this case, it is ( B1 and E1) and the result is -1 from B2
A B C D E
1 ABCDE ABCD ADF AB ABCD
2 -5 -1 2 1 3
I want to use the lenght formula in minifs formula
something like =minifs (A2:E2;A1:E1;len(A1:E1)=4) or =minifs (A2:E2;A1:E1;"len(A1:E1)=4") or =minifs (A2:E2;A1:E1;"len(A1:E1)="&4)
unfortunately, none of these is working for me. I do not know how to write correctly the criterium for the criterium rage.
I know how to do it for simple criteria like =; >,"" or e.g. for minimum where the criterium is the appearance of letter "C" in the criteria range. In this case, it is A2/B2/E2 and the result is -5 =minifs(A2:E2;A1:E1;"*C"). Unfortunately, I do not know ow to use the formula LEN in the criteria.
Bookmarks