Forum Discussion
Peter_BR2000
Apr 04, 2024Copper Contributor
Counting number of unique values in a column
Hi,
Very basic question.
I'm looking at data from over 6000 patients. In a given column that contains various WHO diagnosis codes I want to enumerate/sum how many patients have diagnosis X, how many have diagnosis Y, how many have diagnosis Z etc. How do I do that?
Other columns will contain other information, but the principele should still be applicable.
Kind regards,
Peter
- Riny_van_EekelenPlatinum Contributor
Peter_BR2000 Create a pivot table.
Diagnosis code in the Row area and PatientID in the Value area. Just make sure that the aggragation is set to Count, not Sum.
- Peter_BR2000Copper Contributor
Thank you Riny_van_Eekelen