I should have clarified that better as well.Īfter I filter on true or false I get an #NAME? error by the way. I understand the misunderstanding because it was already 3 in a row with the first 3 cards. So if the K on 765 doesn't give a 4th consecutive card. It must the be the 4th card that changes the sequence. Your method seems to work but I see an issue. But I thought maybe leave it in there so it might give you some ideas. You don't have to use the method I used there. So I made a simplified file.Īlso I put in the paired column in column C. In my complete document I have almost 200 different combinations. I enclosed an example where I put in 3 different 3 card examples. Please don't hesitate and ask me to clarify. Since an 8 would not make 3 consecutive cards with A43 for example. In the enclosed file I showed for T95 how I would like to see it. Since they are letters and not numbers.Ģ.
But I am concerned if 9TJ can be seen as such as well. The numbers 2-9 are logically consecutive for Excel. With 765, both an 8 and 4 give 4 consecutive cards(87).ġ. With A43 a 2 gives 4 consecutive cards(A432). An 8 and J gives 3 consecutive cards with T95(JT95 and T985). The 4th card from column B in combination with 3 cards from column A. I need a formula that enables me to filter on 3(or more) consecutive cards.
With your help I was able to solve problems in the past.
