How to get values according to selected listbox value.

[#1]

Hi All,

I have 1list box named Continent and one column country ,at the sheet level.

As per the requirement I need to write a code so that i can get the following output in a textbox as a heading:

Continent Asia has countries: India,Pakistan,China...... (all the countries should be displayed accordin to continent).

Please tell me what code i need to write and when to call this code.

It is very urgent. Help me on this.

Thanks in advance

[rwunderlich]

Do you only want to display when a single Continent is possible? If so then:

=if(GetPossibleCount(Continent) = 1, 'Continent ' & Continent & ' has countries: ' & concat(Country, ', '))

-Rob

[#3]

Thank you so much Rob for the reply.

One issue is coming that is like Country is not primary key. So i am getting repeated country how can we resolve it ?

Thanks in advance.

[boorgura]

You can use concat(DISTINCT <>)

Let me know if it resolves your issue.

[#5]

Thanks Rocky ... it is working.