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.

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