is there a way to do this in excel?
1) list of items ( variable amount - for example 16 items but each time could be different number )
2) excel will ask you pick between two
choose 1 vs 2
choose 1 vs 3
choose 1 vs 4
and so on until all variations are presented.
3) excel keeps the times that each number is choosen.
4) at the end a chart of each item and sort able by item and how many times it was choosen...most and least and by item name.
is this possible?
thank you.
Bookmarks