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
Highlighted

Thank you so much!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies