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
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