Counting number of unique values in a column

Copper Contributor



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,



2 Replies

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