need to show all the values in listbox 2 minus the value that is selected in List box 1

[Anonymous]

I  need to show all the values in LB2 minus the value that is selected in LB1. e..g LB1 has A,B,C,D as values and LB2 has same values.

When I select A in LB1 , LB2 should list only B,C,D

[MarcoWedel]

Hi,

one solution could be:

=Aggr(If(GetSelectedCount(value),Only({1-$} value),Only(value)),value)

hope this helps

regards

Marco