Calculate Change between Multiple Records

[Leah T.]

I have set up a spreadsheet to record health data of clients on a quarterly schedule. I would like to be able to see if the individuals' "Metabolic Syndrome" status has changed over time (from one quarter to the next).

I'm not even sure where to start in creating a formula! Any ideas?

Simplified version of the spreadsheet:
A1 Quarter (e.g. 2009-Quarter1)
B1 Client's Name
C1 Metabolic Syndrome Yes/No
D1 Metabolic Syndrome Change Yes/No (???)

Thanks,

Leah

 

[shyrath]

I had a quick look, and this may just work.

Will at least give you an idea

Excel Workbook
	A	B	C	D	E	F
3			A1 Quarter (e.g. 2009-Quarter1)
4			B1 Client's Name*
5			C1 Metabolic Syndrome Yes/No
6			D1 Metabolic Syndrome Change Yes/No (???)
7
8
9	KEY	Q	Client	Meta	key	Change
10	AYes	1	A	Yes	AYes	Yes
11	ANo	2	A	No		0
12	ANo	3	A	No		0
13	ANo	4	A	No		0
14	BNo	1	B	No		0
15	BYes	2	B	Yes	BYes	Yes
16	BNo	3	B	No		0
17	BNo	4	B	No		0
Sheet4