Array formula - show only unique records without blank rows

[Mandark]

Hi,

I know this can be done using array formulas, but I am not expert in them so maybe you can help me out. I have two tables:

[TABLE="width: 500"]
<tbody>[TR]
[TD]location[/TD]
[TD]name[/TD]
[TD]value[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]Lucy[/TD]
[TD]0[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]Fiona[/TD]
[TD]0[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]Jane[/TD]
[TD]1[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]Jane[/TD]
[TD]1[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]Lucy[/TD]
[TD]1[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]location[/TD]
[TD]value[/TD]
[TD]name[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]1[/TD]
[TD]Joe[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]1[/TD]
[TD]Karl[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]1[/TD]
[TD]Joe[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]EUR[/TD]
[TD]1[/TD]
[TD]Frank[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD]0[/TD]
[TD]Karl[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
</tbody>[/TABLE]


These tables are on the same sheet and are linked to a external source, so number of rows can change. There are two blank rows between the first table and the second table.

What I would like to achieve is: From these two lists of names (approx. 3000 names each table), I want to get a small list of names on second sheet where:

- every name is just once (no duplicates)
- only names where value is 1 and location is EUR
- no blank rows in the resulting table
(option - merging the two conditions into one)


Example:

[TABLE="width: 100"]
<tbody>[TR]
[TD]name[/TD]
[/TR]
[TR]
[TD]Jane[/TD]
[/TR]
[TR]
[TD]Lucy[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[/TR]
[TR]
[TD]Frank[/TD]
[/TR]
</tbody>[/TABLE]

Can this be done via array formulas?