evaluate a list of items against each other

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.

It should be possible, though the details depend on how you want it to look. I've attached a sample with only four items, but the formulas should hold for more items (add "e" to A6 and it automatically updates). In D3 I use:

=IFERROR(IF(COUNTA($A$1:$A$20)-MATCH($D2,$A$1:$A$20,0)=1,"",IF(COUNTIF($D$1:$D2,$D2)=COUNTA($A$1:$A$20)-MATCH($D2,$A$1:$A$20,0),INDEX($A$1:$A$20,MATCH($D2,$A$1:$A$20,0)+1),$D2)),"")

And in E2:

=IFERROR(INDEX($A$1:$A$20,MATCH($D2,$A$1:$A$20,0)+COUNTIF($D$1:$D2,$D2)),"")

Fill both down beyond what you need and they should produce your permutations. Once choices are made, you can use COUNTIFS to get your totals. Take a look, see if it gives you any ideas: