Query to Return Results Based on Specific Criteria

Hi,

I work with a chemotherapy prescribing system and would like to identify regimes that are Oral only (none intravenous). Some regimes include both, or are IV only.

I have a sheet with 2 columns, A gives prescription name and B gives route i.e. Oral/IV. An example:

Rx 1	Oral
Rx 1	IV
Rx 2	Oral
Rx 3	IV
Rx 4	Oral
Rx 4	IV

I need a query that would only return Rx 2 - in my example, Rx 2 is the only one to have Oral and no other routes associated.

Is this possible in Excel?

Many thanks