Listbox

[everest226]

HI i have a field name [tp IASS] which has value if  aa,ab,ac,ad ,  i only want to show Aa,ac,and,ad.  in listbox

[YoussefBelloum]

Hi,

try this:

=if(match(field,'value1','value2','value3',..'valuex'), field)

[vishsaggi · Accepted solution]

Try like

= IF(Not Match([tp IASS], 'ab'), [tp IASS])