Match

[johnan]

Hi,

I have this:

1	2	3	4
500936	27371385	ABI	AL
500936	27371389	ORD	AL
500936	27371405	BUF	FS
500936	27371415	ORD	FS
500936	27371437	ORD	FS
500936	27371469	ORD	AL
500936	27371494	ORD	AL
500936	27371499	ORD	PK
500936	27371512	ORD	PK
500936	27371514	ORD	PK
500936	27371552	FLA	PK

Ok, i just wanna have one box that showing if column 1 (order) just contains from column 3 FLA or /and ABI

I have this in my box:

=if (not match(Column 3, 'ORD','BUF'),Column 1)

This not working, if there is both ABI and FLA on the same order (Column 1) it will not show it just showing FLA OR ABI not the both if there is. What can i do?

Br

[johnan]

Sorry, the order 501363 it's contains ORD

[tresesco]

So you mean -those orders that contain 'FLA', 'ABI' and Not 'ORD','BUF' ? Try like:

=Concat ( Distinct {<[Column 3]={'FLA','ABI'} - {'ORD','BUF'}>} [Column 1]) , ',')

[johnan]

Sorry mate, doesn't work, it's still shows orders that contains ORD,BUF

I mean, those orders that's contains Only ABI or only FLA or ABI and FLA

Br

[tresesco · Accepted solution]

Yes. I am sorry, the expression needs to be corrected. Try:

Concat(DISTINCT {<[Column1]=P({<[Column3]={'FLA','ABI'}>})>-<[Column1]=p({<[Column3]={'ORD','BUF'}>})>}[Column1], ',')

PFA

[johnan]

Mate..THANX