Filtering/sortering

Deleted
Not applicable

Hi my first visit on the forum! Hope anyone can help me!

 

To illustrate my problem: Say I have a base column A with all countries in the world. Then I need to sort/filter in a column B with all European countries together with column C covering the number of inhabitants and then column D with the name of respective capital.

So, I want to distribute the rows in the three additional columns with the European countries including the associated data so that they are distributed on the corresponding country-row according to column A. Does anyone have a good solution for that? Thanks!

1 Reply

@Deleted 

 

See attached document with proposed solution. I would use:

 

=FILTER(C4:E11,ISNUMBER(MATCH(C4:C11,H4:H7,0)))

 

Assuming you have a range/list with only european countries so that we can reference them in order to filter.