I am trying to make a version of poker on excel but I am unable to create a way to check if the players have a straight or not after all cards are "dealt" (they are dealt with random number generators). I found a way to check if all numbers are consecutive which goes somewhat like AND(A1=B1+1,B1=C1+1, and so on. But I cannot find a quick way to apply this to all possible ways the numbers could form straights. Unless I write out every possible combination. Is there a way to make all combinations visible or just a way to speed up the process?