Mar 16 2019 05:50 PM
I have a file with case numbers and case types in a given month. I want to know which case type is the most common. How can I get a count of the number of rows in each case type?
Mar 16 2019 06:19 PM
Mar 17 2019 09:51 AM
hello
Shared two images hope you find the solution@Jenny-Amari
Mar 17 2019 01:27 PM
A different mindset, stemming mainly from personal prejudices! To avoid the need for helper cells, I introduced names and loaded the array formula
= COUNTIF( CaseType, CaseType )
into the 'Refers to' box for the named formula 'occurrences'. The innovatively-named cell value 'maxOccurrences' is then given by the worksheet formula
= MAX( occurrences )
Knowing the number of occurrences I am looking for, the case type is given by
= LOOKUP( 2, 1/(occurrences=maxOccurrences), caseType )
Thanks for the borrowed problem layout!