We are in need of help with an Excel formula.
Below are two examples, the first one of the raw data and the second one shows the data how we need it to display after the formulas are applied.
Column A – Pt ID (patient id) - This column in the spreadsheet can have multiple rows with the same PT ID
Column B - Impression - There is only one choice for this field. The formula =IF(Sheet1!A3=Sheet1!A2," ",Sheet1!B2) creates a blank cell if there is multiple Impressions for the same PT ID as in Example 2
Column C – Treatment – There can be more than one choice for this field. We need a formula to eliminate duplicates and only shows one of each type of choice for the same PT ID as in Example 2.
Example 1 – Sheet 1
A ``````````````` ``````B ``````````````` ``````````C
PT ID ``````````````` Impression ``````````````` Treatment
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
112 ``````````````` Fever/Infection ``````````````` Albuterol
112 ``````````````` Fever/Infection ``````````````` Atrovent
Example 2 - Sheet 2 with formulas (the expected outcome after the missing formula is applied)
A ``````````````` ``````B ``````````````` ``````````C
PT ID ``````````````` Impression ``````````````` Treatment
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
112 ``````````````` Fever/Infection ``````````````` Albuterol
112 ``````````````` Fever/Infection ``````````````` Atrovent
Below are two examples, the first one of the raw data and the second one shows the data how we need it to display after the formulas are applied.
Column A – Pt ID (patient id) - This column in the spreadsheet can have multiple rows with the same PT ID
Column B - Impression - There is only one choice for this field. The formula =IF(Sheet1!A3=Sheet1!A2," ",Sheet1!B2) creates a blank cell if there is multiple Impressions for the same PT ID as in Example 2
Column C – Treatment – There can be more than one choice for this field. We need a formula to eliminate duplicates and only shows one of each type of choice for the same PT ID as in Example 2.
Example 1 – Sheet 1
A ``````````````` ``````B ``````````````` ``````````C
PT ID ``````````````` Impression ``````````````` Treatment
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
112 ``````````````` Fever/Infection ``````````````` Albuterol
112 ``````````````` Fever/Infection ``````````````` Atrovent
Example 2 - Sheet 2 with formulas (the expected outcome after the missing formula is applied)
A ``````````````` ``````B ``````````````` ``````````C
PT ID ``````````````` Impression ``````````````` Treatment
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
111 ``````````````` Cardiac Arrest ``````````````` Epinephrine 1:10
111 ``````````````` Cardiac Arrest ``````````````` Sodium Bicarb 8.4%
112 ``````````````` Fever/Infection ``````````````` Albuterol
112 ``````````````` Fever/Infection ``````````````` Atrovent