Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try this:
=if(match(field,'value1','value2','value3',..'valuex'), field)
Try like
= IF(Not Match([tp IASS], 'ab'), [tp IASS])