Match with dynamic values from field

[pepe2209]

Hello

I was trying to create a match function where the values to match with are dynamic by a field. I thought of something like this but it's not working:

=match( 'D', concat(distinct(FIELD), ', '))

and FIELD is something like this

FIELD
A
B
C
D
E
F

so if 'D' is present within FIELD it should give a number >0 (in this case 4). does anyone know if this is possible?

your help would be much appreciated

regard,

Peter

[SunilChauhan]

Try this

=match( concat(distinct(FIELD), ', '), 'D')

[jerem1234 · Accepted solution]

You'll need to do something similar to this:

match('D', $(=concat(distinct chr(39) & FIELD & chr(39), ','))

Hope this helps!

[#4]

try this:

max(Match(FIELD,'D'))>0

if this = 1 so 'D' is present within FIELD

Hope this helps

MC

[maxgro]

define a variable

v     =chr(39) & GetFieldSelections(FIELD, chr(39) & ',' & chr(39)) & chr(39)

expression should be

=match('D', $(v))

see attachment

[pepe2209]

This is exactly what i need thanks!