How to find the most frequent combination.

[winds]

text	Alfred	Betty	Charlie	Daisy	Farah	Gosling	Harding
type	0	40	450	56	356	46	456
Character	20	40	59	0	34	4	0
look	40	0	0	0	0	456	0
feel	59	0	0	45	0	0	456
Strength	59	59	40	54	6567	0	45
Visual	30	37	35	235	56	456	4
Asthetic	0	58	2224	234	345	546	0

Hello everyone. I have data that looks something like this and would like to find out the most frequent combination occuring in relation to the column and the row heading after accounting the 0's.

To explain more clearly, referring to the example above for column heading, most frequent combination occuring appears to be Betty, Charlie and Farah which are similar where the zero's occur in the same rows. Likewise for the row headings, this equates to type, character, strength, visual and asthetic.

On a deeper level for the row heading only, most common occurence appears to be for character, strength, visual and asthetic.

It would be ideal to have the formula(?) be able to show these two types of results.

 

[Snakehips]

@winds Will there always be at least one 0 per column?

 

[Peter_SSs]

Duplicate to: How to find the most frequent combination in a dataset.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.