Forum Discussion
Formula for playing cards
- 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.
Thank you so much. You are the best!
Just to be sure. I don't have to add column E with this filter anymore right? Column D with it's filter is sufficient now?
=OR(VARPA(SEARCH(LEFT(A4,1),cardsLO),SEARCH(MID(A4,4,1),cardsLO),SEARCH(MID(A4,7,1),cardsLO),SEARCH(LEFT(B4,1),cardsLO))=1.25,VARPA(SEARCH(LEFT(A4,1),cardsHI),SEARCH(MID(A4,4,1),cardsHI),SEARCH(MID(A4,7,1),cardsHI),SEARCH(LEFT(B4,1),cardsHI))=1.25)
Since you are able to filter out 4 connected cards. Are you able to filter out ''gutshots'' as well? What I mean by that is that exactly 1 card makes a straight.
So for example 567+9, the 8 makes the straight here.
Or 568+9, a 7 makes the straight.
Or 579+6/8, a 6 or 8 make a straight
Or 569+8, 7 makes the straight
Thank you again. You have no idea how much I appreciate you!
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.
- Haha I would if I not already had that. The suits follow a logical pattern in my document. So I was able to solve that issue without a formula. But thank you anyway.
https://gyazo.com/f1f4184de71d77cc5f65f4ab2b8113e8 - You are the absolute best. I already feel like overreaching but you just go over the top be adding another thing.
A thousand thanks! Kalthof "n/c" is commonly used for "no change" but I replaced false with "-" in the attached and added the 3 of a kind, 4 of a kind, and 2 pair also 🙂
it was kind of neat how it worked out. I found out how many times the new card # was in the flop and then:
if 0 do everything as before
if 1 then found a "pair"
if 2 then found 3 of kind
if 3 then 4 of a kind
then I went back to the pair and checked if 2 of the cards had a pair in the flop and if so then 2 of a kind otherwise just a pair.
Do you mean ''not connected'' by n/c? I would rather have FALSE replaced by ''Nothing'' or ''None''. Or at least something so I can rename it later in time.
For the flop It is not necessary to have something. Thank you.
What would be great though. Is add a ''Three of a kind'' (and ''Double paired'') filter option. On 554+5 for example (554+4). But you have already done so much. So don't feel obligated whatsoever.
Kalthof Updated accordingly. I left the "paired" column in just for you to compare if you like but it isn't needed now. Are you sure you want "FALSE" shown for the rest? maybe "n/c" instead? What about pairs or 3 connected on flop? Should those have anything like "n/c - pair" and "n/c - 3 connected"?
My goal is to make rename the FALSE and TRUE names in this list. I am not the only one to use this worksheet so I need to clarify things for them. In the formula you included "4 connected" for example. I really like that you included this. And I know that I can rename this. But TRUE/FALSE is not in-between quotation marks. So I don't know how the rename that. ''3 connected'' is easier to understand than ''TRUE''.
https://gyazo.com/4a92e07ce7c787ddce6c6778bf75d5f1
Can I just add the paired column to formula in the ''Straight'' column as well?
=IFERROR(IF(FIND(LEFT(B4,1),A4),"Exist","Not Exist"),"Not Exist")
I tried to add it between these lines of your formula. But it didn't work.
= IF((A4="")+(B4=""),"",
IF(("Check for 4-card straight"="")+
My goal is to have everything under 1 column. It looks cleaner and people can just choose in the list what they want to filter for.So that the list would become like this:
- Paired
- 4 Connected
- 3 Connected
- Gutshot
- Nothing
- if i miss-read your last question and you are asking HOW to add more text notes like I did the answer is that I used the OR(....) statements to add an additional term in the for ("this does xyz"="") which will always be FALSE and therefore never 'add' or affect the outcome of the OR() statement. Another alternative is if you have (or add) an AND() in which case you simply replace the = with <> in which case that comparison will always be TRUE and once again not affect the AND() statement.
- you can certainly sub different outputs as you see fit
in the name manager, when you click on the table range and say format as a table excel will insert that name into the name manager (i.e. you don't need to and shouldn't as I don't know how excel will "take" it and if it will auto add rows correctly)
and I added those "this does xyz"<>"" part as a way to describe what that part of the formula is doing. It does make the formula longer but it is already really long with out them so a little more doesn't hurt and could be really really helpful a year from now when you or someone else try to figure out what it is doing (IMHO) - I read I can add quotation marks with text to the formula. But it has become so big that I am not sure where to put it in the formula.
- Thank you so much. You are amazing!
I have 2 final questions. Is it possible to rename TRUE for ''3 Connected''? And FALSE for ''Non''.
And in the Name Manager. Besides cardsLO and cardsHI, do I also have to create the Table1 name? I did now but I am not sure if it is even necessary.
https://gyazo.com/37d8c728613ad7313be7b14a53f76080
For as far I can see the formula works perfectly. Many thanks! No worries. You deserve all the likes I can give you haha. And indeed this is always an inside straight.