Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a way to exclude data in a list box?

For example: 

Example List Box1
32578977
34562877

23125967

I need to look up last 2 digits for my exclusion and my exclusion criteria is 77
So the List Box should only show:
23125967
1 Solution

Accepted Solutions
Not applicable
Author

for that make the list box use an expression:

if(right(yourfield,2)<>'77',yourfield)

View solution in original post

2 Replies
Not applicable
Author

for that make the list box use an expression:

if(right(yourfield,2)<>'77',yourfield)

Not applicable
Author

Thanks!