Calculating scores for same patient? (new with excel)

Hi guys,

This might be a very simple question. I hope someone can help me with this because I'm kind of new with Excel.
I have a database with patients who are numbered 1 to 1200 (1200 patients in total). These patients were given painmedication and scored their pain with a simple yes or no answer. Yes =1 no = 0.

The problem is that I have data of the same patient on t=0 en t=4. T=0 means before the patient was given the painmedication and t=4 is 4 months after the painmedication. I asked these patients to score their pain (with yes/no) on t=0 and t=4. Now I'm trying to calculate the difference. Let's say patient number 5 answered yes( =score 1) on t=0 and on t=4 answered no (=0). In the Excel database it looks like this:

Patientno Time Pain yes/no (yes=1, no=0)
1 t=0 1
1 t=4 1
2 t=0 1
2 t=4 0
etc.

Now I want to make a formula to calculate the difference in painscores. For example the difference in patient number 1 is 0 (on t=4 the score was 1 and the score on t=0 was also). For patient 2 the difference is minus 1 (0 on t=4 minus 1 on t=0). I'm kind of stuck here, It takes too much time to calculate this without a formula. Could anybody help me or point me in the right direction. It's very appreciated

Thanks for reading!

Michael

Tanks for your reply! I'm afraid I still don't quite understand. I have to attach a new workbook on the file, but after that is there a kind of formula I should put in? Or could you please send me a link or someting to a video explaining this. The problem now is that I can't calculate the difference between t=4 and t=0 for the same patient. For example patient number 2 had a difference of minus 1 in my example, but I can't calculate this with a simple formula on excel because then it will calculate the difference on t=4 and t=0 for patient number 1 (which is what I want) but also the difference on t=0 en t=4 for patient 2 and 1( which is something I don't want; I just want the difference on t=4 en t=0 for the same patient)

Thanks in advance!!

Originally Posted by Michael.s90

Tanks for your reply! I'm afraid I still don't quite understand. I have to attach a new workbook on the file, but after that is there a kind of formula I should put in? Or could you please send me a link or someting to a video explaining this. The problem now is that I can't calculate the difference between t=4 and t=0 for the same patient. For example patient number 2 had a difference of minus 1 in my example, but I can't calculate this with a simple formula on excel because then it will calculate the difference on t=4 and t=0 for patient number 1 (which is what I want) but also the difference on t=0 en t=4 for patient 2 and 1( which is something I don't want; I just want the difference on t=4 en t=0 for the same patient)

Thanks in advance!!

Hi Michael,

What is being asked , is for you to supply a sample workbook with a "Little" non sensitive data in it ,
That shows your Input and any expected Output from that data. (Manually rigged up is fine)
Like the Simple workbook I have attached here .
This Lets the Others have a look at what you are trying to do without typing in lots of data , and suggest different solutions.

Hope this Helps.