I have the following countif function to count the number of black hondas
=COUNTIFS(table1!A:A,"Honda",table1!B:B,"Black")
and the following to get which Honda is more: black or white
= MAX(COUNTIFS(table1!A:A,"Honda",table1!B:B,"Black"),COUNTIFS(table1!A:A,"Honda",table1!B:B,"White"))
But I want to also display "Honda" next to the value and after I search I composed the following formula
=INDEX(A1:A7,MATCH(MAX(COUNTIF(A1:A7,A1:A7)),COUNTIF(A1:A7,A1:A7),0))
but I can't get it to work when combined with the previous two.
Bookmarks