View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tubster Tubster is offline
external usenet poster
 
Posts: 3
Default Complex Array sorting issue

I have a range of Question responses from a survey that I'm seeking to find
the most common response combinations from. Simply sorting the data doesnt
acheive that succesfully

Data is in the following format in a table 100 rows deep by 53 colums wide

Respondent Q1 Q2 Q3.... Q53
R1 1,1,0,1...1
R2 0,1,0,1,..0
R3 0,0,1,.....0
R4 1,1,1,.....0
R5 1,0,1,0...1
....
R100 0,0,0,1,..0

What I am seeking to work out is what are the Largest 10 combinations and
the Question numbers that make that combination - not just a ranked count of
the responses
Eg Top Combination is Q1 and Q2, and Q53

I'm working thru using arrays but can't find a suitable method to get a
result so far

Any guidance appreciated warmly - I have to repeat this over multiple other
sets of similar data and would like to do it via a reusable approach.