Forum Discussion
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, h...
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.
Thank you Riny_van_Eekelen
