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

Project name	Action	Priority
Blue	Contact Mark	Top priority
Blue	Sign agreement	Not top priority
Blue	Finalise presentation	Top priority
Red	Call Jessica	Top priority
Green	Schedule meeting	Not top priority

<tbody>
</tbody>

Output tab

Project name	Action	Priority
Blue	Contact Mark	Top priority
Blue	Finalise presentation	Top priority
Red	Call Jessica	Top priority

<tbody>
</tbody>

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