One column of my data sheet has data for various health issues ( person x1 has diabetes, hypertension; person X2 has diabetes, hypothyroidism; person X3 has hypertension and arthritis; etc.) for about 3000 people. Another column has data for their side effect of their treatment (like headache, nausea, giddiness, insomnia, etc.) again in one column.
I would like to know if there is a way, in excel, to analyse how many diabetics had nausea, or how many hypertensives had insomnia an other relationships.
I have basically tried to create separate columns for each and give a yes no response but I somehow am not able to combine all these comparisons. Does pivot tables help? and could I do this without VBA as I am an absolute VBA illeterate?
Thanks in advance for any help.
Regards
Amrt