LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A somewhat complex (to me at least) Nested IF issue The Narcissist Excel Worksheet Functions 0 January 23rd 08 12:07 AM
Complex Sorting Patty Kulesavage Broad Ripple HighSchool Excel Discussion (Misc queries) 3 August 30th 07 09:54 PM
Complex countif of array elements Biff Excel Worksheet Functions 1 February 9th 06 08:52 PM
Complex Sorting Problem tx12345 Excel Worksheet Functions 0 December 13th 05 05:13 AM
Help with complex index array issue kkendall Excel Worksheet Functions 4 August 5th 05 10:15 PM


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"