Hi All,

I have this formula:

=LET(s,FILTER(O12:O44,LEN(O12:O44)=MAX(LEN(O11:O44))),MID(s,SEARCH("R",s,1)+1,2)+0)

which works beautifully.

However, today I noticed that if:

1. The MAX string length in range O11:O44 is 25, the formula gives a #value error.
2. The MAX string length in range O11:O44 is 26, the formula gives a #spill error. There is other data around this in nearby cells, so I understand that.
3. When the string length is >=27, it works perfectly.

Generally, my string length is >27 anyway, that is probably why I have not noticed it before.

This is an example of the string that caused the errors: "1300m R10 Event Hire bm64" - without the quotes.

It is no problem to fix, because I wrapped an IFERROR around it and automatically added some text in the middle of the string to lengthen it, but I would like to understand why the 25 & 26 string length affects this.

The formula does not make reference to a minimum strength length.

Any explanation to help me understand would be great.

Thanks