Alternate State

[Anonymous]

Hi All,

I have to display the Selected Alternate state value in List box in Text box.

For example:

Week1     week2(Alternate state of week1)

1                    1

2                    2    

3                    3

4                    4

I have Selected 3 in Week2 list box and want to display it on text box, how to do?

Thanks

Manish

[sunny_talwar · Accepted solution]

Try this:

=Concat(DISTINCT {NameOfYourAlternateStateHere} [Week 1], ', ')

[Anonymous]

Thanks Sunny, it worked 

[sunny_talwar]

Awesome