Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A somewhat complex (to me at least) Nested IF issue | Excel Worksheet Functions | |||
Complex Sorting | Excel Discussion (Misc queries) | |||
Complex countif of array elements | Excel Worksheet Functions | |||
Complex Sorting Problem | Excel Worksheet Functions | |||
Help with complex index array issue | Excel Worksheet Functions |