I want fectch list using two condition in same column

[Manjunathared]

Hi 

C	Status
B-Supv	1
B-Scan	2
B-Bscan	2
B-Seg	1
B-Load	3
S-Seg	2
S-Load	3

In this table want to list 2 status at a time 

used  this code not working-- select(Atend_List[List], [Status]=1 and 2)

Example :

status 1, 2, 3

i want to dropdown status 2 and 3 

can any help me in listing status 2 and 3

[dbaum]

It's unclear what you're trying to accomplish.

One clear issue is your expression's syntax. Review the syntax of the AND function.

AND([Status]=1, [Status]=2)

It seems also likely that the AND function may not be what you need. Contrast the purpose of the AND and OR functions.

OR([Status]=1, [Status]=2)

[Manjunathared]

hi dbaum 

thank you 

select(Atend_List[List],and ([Status]<>3, [Status]<>2 )) 

this syntax worked