excel formula to combine like pairs

Reply #11

thamizhpayan — Wed, 11 Oct 2017 15:54:23 GMT

Hi,

Try to use macros in excel. You don't have to copy paste.

You can simply specify ranges and let excel do what you want.

BTW, did you try the HTML version that I gave earlier. Version 1.2 gives you combos as you expected

Good Luck

Reply #10

Hoster — Thu, 05 Oct 2017 23:32:38 GMT

OKAY HOPE THIS HELPS SOMEONE ELSE

See the example and steps below. and remember no one said this was easy yet.

combine pair sets. It is tedious for larger data because every time you add a pair into Pairs set 1, you have to add another 4 cells to the right of D1 combined and call it E1 combined.

I split this example up into 2 pair sets so you can see what is comparing to what and how it comes out.

On the right are 4 combined areas. each area represents one for cell A1, and one for ce... [ More ]

Reply #9

thamizhpayan — Thu, 05 Oct 2017 03:09:22 GMT

Hi,

Try v1.2 of my pairs combinator tool : https://drive.google.com/open?id=0B4Qt2_2g3zs5SWdqMEk0N1dXNzQ

Just extract to a folder and then open the HTML file. I added another form to enter pairs and print combos(all possible orders) and box combos of the straights created from the pairs. There is a sample output screenshot in the same zip file.

Good Luck

Reply #8

Ricklou — Sun, 01 Oct 2017 21:15:19 GMT

Thats it

Reply #7

Raven62 — Sun, 01 Oct 2017 14:11:39 GMT

Maybe it's Time for another LP Pick 3 Tool to Join Pairs (Str8 Boxed

Reply #6

Oscargrouch05$ — Sun, 01 Oct 2017 08:00:08 GMT

Pairs with spaces on one line using one cell example =CONCATENATE(A3,B3, ,B3,C3) shows as 28 84

Reply #5

Oscargrouch05$ — Sun, 01 Oct 2017 07:35:16 GMT

I made this in excel first number on the left are 1st position 4,2 Second position 7,8 i'm starting to work on that last number i use Excel 2003 any tips on that last position welcome any idea as well for reducing the amount of numbers . I used my own format of flip numbers using 666 system, 317 Rundown, mirror and 6 and 3 system, plus 21 pairs why i used them is if you use anything like =MOD(SUM(A3-8),10) you will have a random numbers from 0 throw 9

using cell A3,B3,C3 A3 (2) , B3 (8) , C3... [ More ]

Reply #4

Hoster — Fri, 29 Sep 2017 17:50:56 GMT

Still looking for excel solution to combine like pairs as in this example

Thanks for your time

Reply #3

Hoster — Fri, 29 Sep 2017 17:14:00 GMT

thamizhpayan thanks this is a handy dandy tool indeed -I have other pairs using long out vtracs which this works great for -because we know where position x is.

however, pairs on the prior post are in randomness -even so they are straight pairs for the most part -but trying to decide which place to put x in is unknown. We have found that by combining like pairs, we get more straight hits than trying to guess where to place them (creates too many combo's).

Reply #2

Hoster — Fri, 29 Sep 2017 16:35:55 GMT

here what I have. it kind of works but only if I hold each cell individually by copy the formula and drop down into a new row. I want to keep the formula in one row.

what i mean - A1:AK1 holds the pairs . A2:AK2 hold the formula. I can make cell A1 in the formula absolute and compare all in row 1. But then to get the next pair to combine I have to copy the formula into A3 then make B1 absolute in the formula. make sense?

pairs are in random order due to the way they are gathered (by differ... [ More ]

Reply #1

thamizhpayan — Fri, 29 Sep 2017 16:15:09 GMT

Try this

https://www.lotterypost.com/thread/311426/5138629

excel formula to combine like pairs

Hoster — Fri, 29 Sep 2017 06:53:16 GMT

looked around LP and net -can't find an excel formula to combine like pairs.

01 02 09, 13, 15, 16, 18 etc. = 012 019 013 135 136 138 etc.

Any help appreciated