User Profile
NotAnExcelWizard
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Trying to return a result based on permutations from a data set
Hi, I've been struggling with a solution to this for a bit and decided to come here for help (sorry if it isn't the best description of the problem). I have a data set that looks like the following: I am trying to create a formula that analyzes permutations of 3 or 4 categories and returns a count value to a table if there are data values >2 in all of the categories. An example of this would be: For the permutation of categories A,B,C (Cells C2, D2, E2), check if each cell contains a value >2. Because all cells do not contain a value >2, nothing happens. For the permutation of categories I,L,Q (Cells K2, N2, S2) each cell contains a value >2. Ideally this returns a result to a table that that adds a count of +1 to the category I,L,Q. I realize the number of 3 and 4 category permutations across 22 categories is huge, so in an even more ideal scenario the table only contains the 20 permutations with the highest count at the end of the analysis. Ideally, the result table looks something like this: Not even sure if this is super feasible with excel or if someone will return some code that will solve all my issues. Either way, thanks to the community for taking a look! Good Luck! P.S. I did come up with a really poor solution that worked for permutations across 2 categories, though it took a while.
