How to show all results based on all switches

%3CLINGO-SUB%20id%3D%22lingo-sub-752023%22%20slang%3D%22en-US%22%3EHow%20to%20show%20all%20results%20based%20on%20all%20switches%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752023%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20financial%20model%20whereby%20there%20are%20various%20%22switches%22%20for%20instance%20Yes%2FNo%20(created%20in%20a%20cell%20using%20data%20validation)%20whereby%20a%20certain%20result%20will%20populate%20if%20the%20answer%20is%20yes%2C%20and%20another%20no.%3C%2FP%3E%3CP%3EI%20have%20multiple%20yes%2Fno%20switches%2C%20including%20other%20switches%20that%20can%20each%20be%20varied%20resulting%20in%20many%20possible%20combinations%20for%20a%20result.%3C%2FP%3E%3CP%3EWhat%20i%20have%20been%20previously%20(and%20tediously)%20doing%20is%20selecting%20the%20switches%20to%20a%20particular%20set%2C%20copying%20and%20pasting%20the%20result%20in%20a%20separate%20table%2C%20and%20repeating%20this%20for%20all%20possible%20permutations%20of%20my%20switches.%3C%2FP%3E%3CP%3EWhat%20i%20would%20like%20to%20create%20in%20excel%20is%20a%20sort%20of%20table%20whereby%20all%20the%20permutations%20of%20all%20possible%20combinations%20of%20the%20switches%20is%20shown%20for%20me%2C%20to%20avoid%20manually%20copying%20and%20pasting.%3C%2FP%3E%3CP%3EPlease%20advise%20if%20this%20would%20be%20possible%20and%20how%20this%20could%20be%20achieved.%3C%2FP%3E%3CP%3EMany%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-752023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752457%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20all%20results%20based%20on%20all%20switches%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752457%22%20slang%3D%22en-US%22%3EPerhaps%20this%20article%20helps%3F%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2FArticles%2FExcelTableRecipe.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjkp-ads.com%2FArticles%2FExcelTableRecipe.asp%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754317%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20show%20all%20results%20based%20on%20all%20switches%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754317%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi all

 

I have created a financial model whereby there are various "switches" for instance Yes/No (created in a cell using data validation) whereby a certain result will populate if the answer is yes, and another no.

I have multiple yes/no switches, including other switches that can each be varied resulting in many possible combinations for a result.

What i have been previously (and tediously) doing is selecting the switches to a particular set, copying and pasting the result in a separate table, and repeating this for all possible permutations of my switches.

What i would like to create in excel is a sort of table whereby all the permutations of all possible combinations of the switches is shown for me, to avoid manually copying and pasting.

Please advise if this would be possible and how this could be achieved.

Many thanks.

2 Replies
Highlighted
Highlighted

Thank you so much!