Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a lot of values in a list box and its hard to select all but one. Is there a way I can use the search function on the list box to exclude a value in the list?
you can use - before your selection to exclude in the search (no space after -)
-Aus will select the green ones
-UK the first 4
-(UK|India) will select Australia, Austria, Port Rico
etc etc....
I don't know about the search, but here are two other options:
1. Click on the value that you do not want to include. Then right click on the list box and choose "Select Excluded".
2. Right click on the list box and choose "Select All". Then holding down CTRL, click on the value that you do not want to include.
you can use - before your selection to exclude in the search (no space after -)
-Aus will select the green ones
-UK the first 4
-(UK|India) will select Australia, Austria, Port Rico
etc etc....
Great. Thanks for the help.
If the answer was helpful, kindly close the post, by marking the Correct and/or Helpful Answer(s).