Home

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
Milica777
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

Thank you so much!

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies