Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
one solution could be:
=Aggr(If(GetSelectedCount(value),Only({1-$} value),Only(value)),value)
hope this helps
regards
Marco