Excel: Dice Roll

I have tried many different functions to get a text response when I roll - 1,1,1,1,1 or 2,2,2,2,2 using five dice. The table has 100 rows and the numbers are random. I've tried if, Vlookup, Hlookup and or.

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

This thread is current as of October 20, 2013.

For more resources for Microsoft Excel