Hello! im just newbie in excel my question is what formula do I need to get just subjects of all Basic and Common type.
My sample dataset;
<tbody>
</tbody>
I want extracted records to be:
<tbody>
</tbody>
Thank you.
My sample dataset;
Type | Subject |
Basic | Subject 1 |
Basic | Subject 3 |
Common | Subject 2 |
Core | Subject 1 |
Common | Subject 3 |
Core | Subject 1 |
<tbody>
</tbody>
I want extracted records to be:
Basic | Subject 1 |
Basic | Subject 3 |
Common | Subject 2 |
Common | Subject 3 |
<tbody>
</tbody>
Thank you.