Counting number of unique values in a column

[Peter_BR2000]

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

[#2]

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

[#3]

Thank you @Riny_van_Eekelen