Forum Discussion
Solved
Formula for playing cards
Dear community, With your help I was able to solve problems in the past. I hope you can help me again. I need a formula that enables me to filter on 3(or more) consecutive cards. The 4th card...
- correct the prior Column E should have been deleted
so basically 4 cards to an inside straight possibilities. I will see if I can come up with something but it will cost you. jk. but a few likes wouldn't hurt. lol.
No, you do not have to copy anything. Please just run a new calculation of the cells (F9) in Error Test and tell me in which cells (A3:A16) the #NAME? error appears.
I ran the calculation but no #NAME? appears.
Here is a Gyazo to show you that. You can also see what happens if I filter on true in the other worksheet.
https://gyazo.com/ad72f19e4622866fe34c5ccfe44d5c84