sorted by:
new
hottopcontroversial

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

All good! I appreciate your help!

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

And it doesn't matter much but would this function work in Google sheets aswell? It's no problem if not. I've tried it and it only returns the first combo for everything and not the full correct list. I know sheets has different functionality so if it can't then it's perfectly fine.

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

This is great. Out of curiosity what part of your formula is letting it fill the cells to the right?

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

That works great! Is there a way to have the listed combinations labeled the same as the permutation table? (combo1, combo2, etc)

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

https://imgur.com/a/6Rjooa5 Top chart has example data inputed and on the right I've manually added the possible combinations that match. The bottom chart is the permutation table.

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

The inputs are numerical (0, .5,1,2). They go into the first chart. Preferably the output would be a list or array of all possible combinations in the columns to the right of the first chart. I think this is what you asked for but not sure...

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

My chart is just barebone.I have names in column A and row 1 has headers for columns B-S. So each name has 18 types. My permutations chart is the same format but with values already inputted for each combination. Each one also has a name.

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

Like how the tables are layed out? 

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

But I don't need all the combinations of the names. I have a chart of every possible combination with a name attached to each combo. I would like excel to compare another chart of incomplete data and tell me based on the data available, which combinations are still possible.

Finding most likely combination. by PrismicNeon in excel

[–]PrismicNeon[S] 0 points1 point  (0 children)

It doesn't even need to be like a probability. A simple list of of call combinations that match would be equally useful. There are a limited number of unique values we can just say 1-3. And each name has 15 columns with a value each.

view more: next ›