D
Dan the Man
I received great help on an early formula, and I'm trying to analyze my data
one other way, and can't seem to think of the best way to write out what I
need. Here goes an example. Any help would be greatly appreciated:
Disch Program Q #1 Q #1
Date at Admit at Disch
Column A Column B Column C Column D
Sep 1, 08 CIC 5 15
(Improvement)
Sep 15, 08 TP 10 10
(Stayed the Same)
Sep 21, 08 CIC 10 5
(Got Worse)
Sep 22, 08 CIC 5 5
(Stayed the Same)
Sep 22, 08 TP 15 10
(Got Worse)
What I want to compare are: improvement, stayed the same, and got worse
within each program. Thus, in the above example, I would look at Improvement,
stayed the same or got worse for individuals in our CIC program separately
from individuals in TP or OP. What I want to obtain is a raw score value that
would tell me:
Of the (3) CIC individuals discharged: 1 Improved, 1 stayed the same, and 1
got worse. I'll do this for the individuals in OP and TP separately, but once
I get one formula I should be able to figure out the others. HELP, I can't
wrap my mind around it. I'm grabbling the data off of one sheet (entitle:
'Raw Data'!), and placing it on another sheet (outcomes). Thus I know I need
to reference/qualify the raw data sheet using the above string of formula as
I attempt to generate the information on my outcomes sheet.
Any suggestions? Hope I provided enough information to solve the formula!
Dan
one other way, and can't seem to think of the best way to write out what I
need. Here goes an example. Any help would be greatly appreciated:
Disch Program Q #1 Q #1
Date at Admit at Disch
Column A Column B Column C Column D
Sep 1, 08 CIC 5 15
(Improvement)
Sep 15, 08 TP 10 10
(Stayed the Same)
Sep 21, 08 CIC 10 5
(Got Worse)
Sep 22, 08 CIC 5 5
(Stayed the Same)
Sep 22, 08 TP 15 10
(Got Worse)
What I want to compare are: improvement, stayed the same, and got worse
within each program. Thus, in the above example, I would look at Improvement,
stayed the same or got worse for individuals in our CIC program separately
from individuals in TP or OP. What I want to obtain is a raw score value that
would tell me:
Of the (3) CIC individuals discharged: 1 Improved, 1 stayed the same, and 1
got worse. I'll do this for the individuals in OP and TP separately, but once
I get one formula I should be able to figure out the others. HELP, I can't
wrap my mind around it. I'm grabbling the data off of one sheet (entitle:
'Raw Data'!), and placing it on another sheet (outcomes). Thus I know I need
to reference/qualify the raw data sheet using the above string of formula as
I attempt to generate the information on my outcomes sheet.
Any suggestions? Hope I provided enough information to solve the formula!
Dan