Select non duplicate values in field

[#1]

I have an inventory number field in a table. I want to select only those inventory numbers that are not duplicates. For example:

Inventory Number
111
112
112
113
115
115
115

Out of the values above I would want to select only 111 and 113. Is there an easy way to do this? Ideally I want a way to do this via a search in a list box containing this field.

[Gysbert_Wassenaar · Accepted solution]

Right click the listbox and select advanced search. Then enter the expression =count([Inventory Number])=1 and press the Go button:

[#3]

Thanks!