Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 6 questions that may be answered yes or no, and for the sake of
keeping everything in integer form, let's assume "1" for yes and "0" for no. Depending on how a customer answers all 6 questions, they will receive a predetermined score. I am attempting to develop the answer key, so-to-speak, to refer the reps to once they are finished asking the customer these questions. I was hoping for the code that would build a macro to create this tabe for me - a table that would lay out all of the 6 question-answer combinations, like the following: Questions Scenario 1 Scenario 2 Scenario 3 Scenario 4 1 1 1 1 1 2 1 0 0 0 3 1 1 0 1 4 1 1 1 0 5 1 1 1 1 6 1 1 1 1 ....and so on, so that I am given all the possible 6 answer scenarios.... Your help is greatly appreciated! Victoria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to build table | Excel Worksheet Functions | |||
Help to build a table | Excel Discussion (Misc queries) | |||
Build a Table | Excel Discussion (Misc queries) | |||
Different ways to build Pivot table | Excel Discussion (Misc queries) | |||
How do I build this Macro? | Excel Discussion (Misc queries) |