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
Bookmarks