Extract all unique cell contents based on combination of two columns

[excellearner17]

I have a long list (over 400 rows) of duplicated project names which have different actions and priorities.
On another tab I want to extract all the project names + action combination that have top priority assigned. How do I do that?

Example

Raw data tab
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project name[/TD]
[TD]Action[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Contact Mark[/TD]
[TD]Top priority[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Sign agreement[/TD]
[TD]Not top priority[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Finalise presentation[/TD]
[TD]Top priority[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Call Jessica[/TD]
[TD]Top priority[/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Schedule meeting[/TD]
[TD]Not top priority[/TD]
[/TR]
</tbody>[/TABLE]

Output tab
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project name[/TD]
[TD]Action[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Contact Mark[/TD]
[TD]Top priority[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Finalise presentation[/TD]
[TD]Top priority[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Call Jessica[/TD]
[TD]Top priority[/TD]
[/TR]
</tbody>[/TABLE]
Thank you! I've been breaking my head trying to figure this out - any help will be very much appreciated!

 

[pgc01]

Hi

If I understand correctly you just have to filter by Priority=Top priority

 

[excellearner17]

Sort of, but I want to do that in another tab without having to copy the whole dataset and then filter - I want a table that refers back to the raw data and extracts the information.
Is this possible?

 

[AhoyNC]

Here is one way.
NOTE: the formula in D10 is an array formula and must be entered with CTRL-SHIFT-ENTER then drag down the row.
Formula in A10 would be copied down and across.

Excel Workbook
	A	B	C	D
1	Project name	Action	Priority
2	Blue	Contact Mark	Top priority
3	Blue	Sign agreement	Not top priority
4	Blue	Finalise presentation	Top priority
5	Red	Call Jessica	Top priority
6	Green	Schedule meeting	Not top priority
7
8
9	Project name	Action	Priority	Row ID
10	Blue	Contact Mark	Top priority	1
11	Blue	Finalise presentation	Top priority	3
12	Red	Call Jessica	Top priority	4
Sheet