Looking for any excel wizards or people willing to try solve a problem I'm facing in excel (Poker related of course:f_biggrin:). I,ll try to explain what i'm trying to do.
Convert a mid/part range into all* combos within that range. *I do not need individual suits, just suited or Offsuit.
Example1:
A7s-A3s --> A3s,A4s,A5s,A6s,A7s
Example 2:
99-KK --> 99,TT,JJ,QQ,KK
Hope it makes sense what im trying to do.
Any help would be much appreciated!:f_thumbsup:
I haven't used Excel much but that sounds impossible or at least very difficult to do 
Maybe you would have to use macros or some other advanced stuff I have no clue about...
I hope we get a reply from some Excel guru.:f_thumbsup:
Pretty sure it can be done. difficulties will be face cards i think. and PP ranges...
Heres a genral idea I'm working with the now.....
Range as formula;
xn1y-xn2y
list numbers bewteen n1&n2
e.g for J7s-J5s;
5
6
7
Then add back in x&y
J5s
J6s
J7s
What is your plan with the information afterwards?
Should be doable with a macro, I'll have a punt at it but knowing what you plan on use it for could help depending.
Will be using it for hand matrix in excel. Customise colours etc from a pasted range.
i've already got a data sheet that has all combos of XYo+,AYs+ & XX+.
So for example:
Was thinking about doing the same for the part ranges, Not sure what the best/ quickest way about it is. there's going to be tons of combos:rage:
Had a think last night but all I could come up with is either a look up table which would involve writing out every combo, which like you say is madness. A second idea is have it split the input then run an if for each number in the sequence, this would require doing A2o- AKo rather then using A2o+ However think it would struggle with the pairs 99+ etc. Will have another play today.
yeah i thought about that. but the problem is the input ranges will be pasted from equilab. so you could have:
JJ+, AKs, A8s-A6s, A4s-A2s, AKo
It currently picks up all hands in the range, but misses out the hands between A8s-A6s, A4s-A2s
so the range will be missing A7s & A3s
I Started to visualise the combos for the biggest set (AQ-A2) and it doesnt seem like its going to be that hard to do.
Once this set is complete, I can just replace A for Q and remove any QQ and Qx+ then repeat.
That's the theory anyway:pcuser: Keep any new ideas coming ♦
Don't quite understand you last post but from the one before:
You mentioned A8o-A6o. So you lookup A6o+ and either remove A8o+ and add A8 again.
Or you simply remove the last length-3 (len) characters.
=replace(CARD1;len(CARD1)-len(CARD2)+3;len(CARD2);"")
card1 is looking up A6o+ and card2 A8o+. len(CARD2) you could replace with large enough number.
=replace(CARD1;len(CARD1)-len(CARD2)+3;100;"")
Thanks for your help Rhodriguez. That's a really intuitive way of looking at it. Unfortuanetly there was a couple problems using that method.
I went for using a sort of look up system with all combos listed. Didn't take that long to do with a couple formulas and Notepad.exe to help with replacing.
Here's a sneak of the sheet
Nice work, I never got very far with it as I couldn't bring myself to do all the combos to use for a lookup
Thanks, Yeah i thought it was going to be massive pain but was fairly straight forward exercise after the longest range once done 
