I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbMostFrequentDuos

This came up in a German Excel Forum: Given a matrix of some club members and when they attended a club evening, which member duo showed up most frequently at these club meetings?

The input:

sbMostFrequentDuos_Input

The output:

sbMostFrequentDuos_Output

The code:

If you are interested in downloading a 33 KB Excel 2010 sample file go to my Download page, please.

sbMostFrequentDuos_Code1
sbMostFrequentDuos_Code2
Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download