Currently I am working on pulling out the max values based off criteria.
However, the array where there =Max(if(iserror(search( array function is search can contain a variety of formats.
Say I want to look up "KD100". I would want to pull back 3 instances:
"KD100" by itself
"*KD100,*", either at the beginning or in the middle of a delimited list
"*,KD100" when it is at the end of the delimited list
The issues is that the last instance ("*,KD100") is hitting when I search for "KD1" and "KD10". Is there a way to denote that I want no text after KD100 in the third instance?
However, the array where there =Max(if(iserror(search( array function is search can contain a variety of formats.
Say I want to look up "KD100". I would want to pull back 3 instances:
"KD100" by itself
"*KD100,*", either at the beginning or in the middle of a delimited list
"*,KD100" when it is at the end of the delimited list
The issues is that the last instance ("*,KD100") is hitting when I search for "KD1" and "KD10". Is there a way to denote that I want no text after KD100 in the third instance?