ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how can i make a drug file names (https://www.excelbanter.com/new-users-excel/149349-how-can-i-make-drug-file-names.html)

medicalofficelaboratoryassistant

how can i make a drug file names
 
given all the drug names to make a file with the generic and the brand names
with the therapuetic classification how can you make a file out of that?

Pete_UK

how can i make a drug file names
 
You should really ask yourself what do you want to do with the file
once it is made. If it is just to be able to find the brand name and
classification from the generic name (or vice-versa), then you could
set up a sheet with three columns - put "Generic" in A1, "Brand" in B1
and "Classification" in C1 as headings.

Then, start entering your data under the appropriate column heading.
Once your data is added, click anywhere in the table and Data | Filter
| Autofilter - you will now see small arrows in the header row which
represent pull-downs. If you click on one of these then you will see a
small panel which lists the available entries in that column, and if
you click on, say, aspirin then only the rows which has that entry in
that column will be displayed. Click the pull-down arrow again and
select All to restore the sheet.

Hope this helps.

Pete


On Jul 8, 7:48 am, medicalofficelaboratoryassistant
osoft.com wrote:
given all the drug names to make a file with the generic and the brand names
with the therapuetic classification how can you make a file out of that?





All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com