I have a list of names and all the countries. Column 1 is filled with names and the following columns represent all the countries of the world. In each row, there's an 'X' under the country that person has visited.
On another tab, I'm listing some of these names using the formula FILTER. In the following column I'd like to list every country where there's an 'X' for that person.
For example, in Cell A3, I have this formula: =FILTER(Table1[Name, first name];Table1[Age]=“20-25”;””), which gives Thomas. In Cell B3, I want all the countries where Thomas has an 'X', so that in Cell U3, I will get: Belgium, Tanzania, Poland.
On another tab, I'm listing some of these names using the formula FILTER. In the following column I'd like to list every country where there's an 'X' for that person.
For example, in Cell A3, I have this formula: =FILTER(Table1[Name, first name];Table1[Age]=“20-25”;””), which gives Thomas. In Cell B3, I want all the countries where Thomas has an 'X', so that in Cell U3, I will get: Belgium, Tanzania, Poland.