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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies