The following calculation will do an exact match of a given text within a value list.
PatternCount ( “¶” & <Value List Items> & “¶” ; “¶” & <Search Value> & “¶” )
|
Instead of looping through the value list and searching for the value that exactly matches the <Search Text>, it’s better to do a PatternCount on the Value List.
|