Only including cells containing certain words / numbers in formula?
I have a new job as a sepsis specialist nurse. At the end of the month, using all the data inputted throughout the month, I have to work out how many high risk patients received IV antibiotics within 1 hours. I would greatly appreciate your help, as I have never worked with Excel before
So the calculation I’m after would be as follows:
Only include only patients categorized as HIGH (column I) which contains either High or Low. Of these I need to take any patient with 01:00 (1 hour) or less (Column Q). Then divide by the total amount of High risk patients to give me a percentage of patients that received IV antibiotics within 1 hour. Hope that makes sense
Thanks for your help
I have a new job as a sepsis specialist nurse. At the end of the month, using all the data inputted throughout the month, I have to work out how many high risk patients received IV antibiotics within 1 hours. I would greatly appreciate your help, as I have never worked with Excel before So the calculation I’m after would be as follows: Only include only patients categorized as HIGH (column I) which contains either High or Low. Of these I need to take any patient with 01:00 (1 hour) or less (Column Q). Then divide by the total amount of High risk patients to give me a percentage of patients that received IV antibiotics within 1 hour. Hope that makes sense Thanks for your help Read More