Excel Experts needed

Reply #3

phileight — Sat, 16 Jul 2011 18:37:13 GMT

Raksters file has 1st set of pairs in cells R8 through R19. second set of pairs is in cells R20 through R36.

he had empty space after line 41 so I put the results in col R starting in line 42. you will need to duplicate these conditions or modify this code to suit your conditions. let me know if I can help. p8

Sub Make_comb()

' take pairs from sheet 1 yellow is 1 set white is second set split into digits make comb if 1 digit of pair

'yellow matches 1 digit in pair white

' pai... [ More ]

Reply #2

Rakster — Fri, 15 Jul 2011 01:19:33 GMT

I sent you a file.. i just entered them in a space I found...lol... but if you can figure it out by all means go for it...lol

Reply #1

phileight — Fri, 15 Jul 2011 00:50:39 GMT

questions the wording says 0 and a 9 but example would indicate or . I'll assume example is correct

where are your pairs? all in col A or 1 set in A other set in B? are the # of pairs always the same or vary?

what col do you want the results to be in

if your data base is in same workbook you could generate a list of matching box hits and game # for each combination. would need to know how your file is structured.

Excel Experts needed

Rakster — Thu, 14 Jul 2011 22:41:56 GMT

Can anyone create for me a tool that can generate numbers from distinct pairs from 2 groups of pairs without it generating numbers from all combined pairs?

I will give you an example of what I want and don't want...

09

04

24

16

27

38

13

57

18

25

47

58

23

56

67

06

26

46

05

17

35

59

14

69

68

12

34

78

19

In the above pairs we start with a 09 pair group...... I ONLY want the 09 pair to comb... [ More ]