Excel: Count and output letters in order

What is the best way to have the table output the letters in certain order and certain number of time. Table has input X,Y,Z . For each X,Y,Z, it shows how many times they are repeated in the output in that order X,Y,Z.

2 1 1 X X Y Z
1 2 0 X Y Y

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of October 30, 2014.

For more resources for Microsoft Excel