diagnosis

Hello I try to create a patient list (As I am doctor) patient has a different diagnosis. I will create an excel file for each patient. So whenever I search a patient with one spesific diagnosis, windows search finds all of these diagnosis, not the one I selected. Is there anyway to stop it...

Hi, I have a table of patients and their diagnoses where eachline contains a separate diagnosis and there can be many lines per patient. I need to convert this to one row per patient with all ofthe diagnoses ordered Primary 1 diagnosis code, Primary 1 DiagnosisDescription, Secondary 1 diagnosis...

I need to reorganize data output as listed below: Source export: Column A | Column B Patient A | Diagnosis Code 1 Patient A | Diagnosis Code 2 Patient A | Diagnosis Code 3 Ideal Output: Column A | Column B | Column C | Column D Patient A | Diagnosis Code 1...

hi, i can not seem to find a solution for this. thank you in advance for tips or links to a solution. the situation is as follows: i have 3 tables that are connected through different cells. i give an example: table1: patient, age 1, 36 2, 67 3, 43 table 2 (patient occur more than once...

Hello- Excel novice here. Given 2 sets of data in worksheet A (a diagnosis column and a diagnosis code column) given just the diagnosis column in worksheet B is there a formula to get the diagnosis code column to populate in worksheet B? Thanks in advance.