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

[tresesco]

Which object are you trying with? For multiple values try like:

=Concat ( Distinct (if (not match([Column 3], 'ORD','BUF'), [Column 1])) , ',')

[johnan]

Just a straight table in diagram.

[prma7799]

if(not match(col3,'ORD','BUF'),col1) it is perfect please check your column spelling

[johnan]

Hi, i'ts not because it wont show if column 3 have both ABI and FLA on same number from Column 1

Br

[prma7799]

Like this you want or please share expected output ..

[tresesco]

Have you tried with concat() as I showed above?

[johnan]

Sorry, i was not clear

1	2	3	4
500936	27371385	ORD	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
500956	27371567	FLA	PK
500956	27371568	FLA	PK
500956	27371569	ABI	PK

I just wanna se order 500956 because it's just contains FLA and ABI

The order 500936 can be ignored i'ts contains ORD and it's not relevant for me.

Just when a Order only contains FLA or and ABI

Br

[johnan]

Sorry, i was not clear

1	2	3	4
500936	27371385	ORD	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
500956	27371567	FLA	PK
500956	27371568	FLA	PK
500956	27371569	ABI	PK

I just wanna se order 500956 because it's just contains FLA and ABI

The order 500936 can be ignored i'ts contains ORD and it's not relevant for me.

Just when a Order only contains FLA or and ABI

Br

[tresesco]

Try:

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