I'm using COUNTIFS to display how many Toyotas there are of each color. e.g. for black toyotas:
= COUNTIFS(A:A, "Toyota",B:B, "Black")
I need a formula that would show the label of that value e.g. "black Toyota"
I tried
= INDEX((A:A,B:B), MODE(MATCH((A:A,B:B),(A:A,B:B),0)))
but it didn't work.
Capture.PNG
Bookmarks