Home

I need to create a matrix that keeps count of varying categories.

%3CLINGO-SUB%20id%3D%22lingo-sub-789398%22%20slang%3D%22en-US%22%3EI%20need%20to%20create%20a%20matrix%20that%20keeps%20count%20of%20varying%20categories.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789398%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20patients%20with%20demographic%20characteristics.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20an%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EPatient%3C%2FTD%3E%3CTD%3EID%3C%2FTD%3E%3CTD%3EDOB%3C%2FTD%3E%3CTD%3EGender%3C%2FTD%3E%3CTD%3EEthnicity%3C%2FTD%3E%3CTD%3ERace%3C%2FTD%3E%3CTD%3EMRN%3C%2FTD%3E%3CTD%3EDiagnosis%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDoe%2C%20Jane%3C%2FTD%3E%3CTD%3E001%3C%2FTD%3E%3CTD%3E01%2F01%2F91%3C%2FTD%3E%3CTD%3EF%3C%2FTD%3E%3CTD%3ENon-Hispanic%3C%2FTD%3E%3CTD%3EWhite%3C%2FTD%3E%3CTD%3E12345678%3C%2FTD%3E%3CTD%3ECD%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESmith%2C%20John%3C%2FTD%3E%3CTD%3E002%3C%2FTD%3E%3CTD%3E02%2F02%2F92%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3ENon-Hispanic%3C%2FTD%3E%3CTD%3EBlack%20or%20African%20American%3C%2FTD%3E%3CTD%3E0246810%3C%2FTD%3E%3CTD%3EUC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKnobi%2C%20Obi%20Wan%3C%2FTD%3E%3CTD%3E003%3C%2FTD%3E%3CTD%3E03%2F03%2F93%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3CTD%3ENon-Hispanic%3C%2FTD%3E%3CTD%3EAsian%3C%2FTD%3E%3CTD%3E36912151%3C%2FTD%3E%3CTD%3EUC%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20matrix%20that%20will%20show%20me%20the%20number%20of%20patients%20that%20meet%20two%20different%20categories%2C%20like%20for%20example%2C%20I%20want%20one%20of%20the%20cells%20in%20the%20matrix%20to%20show%20me%20how%20many%20patients%20are%20Female%20(F)%20and%20also%20Non-Hispanic.%20How%20would%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-789398%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789450%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20create%20a%20matrix%20that%20keeps%20count%20of%20varying%20categories.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789450%22%20slang%3D%22en-US%22%3E%3CP%3Ehave%20you%20considered%20pivot%20tables%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20find%20the%20options%20to%20create%20pivot%20table%20under%20menu%20%22Insert-%26gt%3BPivot%20table%22%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20will%20look%20like%20picture%20attached.%26nbsp%3B%20once%20you%20create%20a%20pivot%20table%20%2C%20you%20can%20drag%20the%20different%20field%20to%20rows%2Fcolumns%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789674%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20to%20create%20a%20matrix%20that%20keeps%20count%20of%20varying%20categories.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789674%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387761%22%20target%3D%22_blank%22%3E%40Nimrah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Pivot%20is%20more%20flexible%20solution%2C%20however%20alternatively%20you%20may%20use%20COUNTIFS%20to%20count%20number%20of%20patients%20using%20criteria.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Nimrah
Occasional Visitor

I have a list of patients with demographic characteristics. 

 

Here's an example:

 

PatientIDDOBGenderEthnicityRaceMRNDiagnosis
Doe, Jane00101/01/91FNon-HispanicWhite12345678CD
Smith, John00202/02/92MNon-HispanicBlack or African American0246810UC
Knobi, Obi Wan00303/03/93MNon-HispanicAsian36912151UC

 

I want to create a matrix that will show me the number of patients that meet two different categories, like for example, I want one of the cells in the matrix to show me how many patients are Female (F) and also Non-Hispanic. How would I do this?

2 Replies

have you considered pivot tables ? 

You can find the options to create pivot table under menu "Insert->Pivot table"  

it will look like picture attached.  once you create a pivot table , you can drag the different field to rows/columns 

 

@Nimrah 

Power Pivot is more flexible solution, however alternatively you may use COUNTIFS to count number of patients using criteria.