Hi MrExcel,
I'm trying to use excel to help me to create a tool to make complex decisions -- to find favourite items or options among a single list of multiple items or options.
This should be relatively simple to program, only I am a newbie at this.
I would really appreciate suggestions on how to code this process:
1. User inputs a number of items/options into LIST A.
2. Excel calculates the number of entries in LIST A and the number of combinations of pairs entries (without any repeats/duplicates).
3. Excel then generates a 2-COLUMN TABLE showing all the possible different pair combinations from the original list.
4. Entries from the 2-COLUMN TABLE are fed into a QUESTIONNAIRE (row by row), using a template "Which option from this pair is preferable? A or B?"
5. The user completes the QUESTIONNAIRE, and the votes for each individual item/option are tallied.
6. The item/option with the most votes wins, and the winning entry is displayed, followed by the runner up, 3rd place, 4th place and so on until all entries on LIST A have been put into order of preference.
END.
Note, ideally the program/code is scalable -- so could be used to for a list of up to "N" entries.
Look forward to hearing your ideas,
Fer9us
I'm trying to use excel to help me to create a tool to make complex decisions -- to find favourite items or options among a single list of multiple items or options.
This should be relatively simple to program, only I am a newbie at this.
I would really appreciate suggestions on how to code this process:
1. User inputs a number of items/options into LIST A.
2. Excel calculates the number of entries in LIST A and the number of combinations of pairs entries (without any repeats/duplicates).
3. Excel then generates a 2-COLUMN TABLE showing all the possible different pair combinations from the original list.
4. Entries from the 2-COLUMN TABLE are fed into a QUESTIONNAIRE (row by row), using a template "Which option from this pair is preferable? A or B?"
5. The user completes the QUESTIONNAIRE, and the votes for each individual item/option are tallied.
6. The item/option with the most votes wins, and the winning entry is displayed, followed by the runner up, 3rd place, 4th place and so on until all entries on LIST A have been put into order of preference.
END.
Note, ideally the program/code is scalable -- so could be used to for a list of up to "N" entries.
Look forward to hearing your ideas,
Fer9us