List box and Multibox options

[#1]

Hi,

Is it possible to show few data only on Listbox and Multibox.

Ex:

Dim1

A

B

C

D

E

So, I want to display A,B,C or Top 5 or last 5 like that.

Thank you.

[its_anandrjs · Accepted solution]

Hi,

You can use conditional statements in the list box for any selected values you can write expression

Ex:-

=IF(Match(Dim1,'A','B','C'),Dim1)

Or you can use your choice expressions.

Regards

Anand

[#3]

Thanks Anand, I got it.