Match winning numbers with group and place them separately by group

[motilulla]

Using Excel 2010

Hello,

1-In the Column C, in the cells C27:C56 I got 30 winning numbers which are from 0 to 36 could be many repeated times.

2-In the Column F, in the cells F2:F23 I have group1 of 21 numbers in the ascending order

3- In the Column G, in the cells G2:G23 I have group2 of 16 numbers in the ascending order

I need VBA which can scan winning numbers of column C, from cells C27:C56 and match with group1 and group2 and then place them separately according to group match Group1 in the column F, cells F27 to down and Group2 in the column G27 to down as shown below in the example attached sheet

Seperate Match As Per Group.xlsx
	A	B	C	D	E	F	G	H	I
1
2						Group 1	Group 2
3						2	0
4						5	1
5						6	3
6						7	4
7						8	11
8						9	13
9						10	14
10						12	15
11						16	19
12						17	20
13						18	26
14						21	30
15						22	31
16						23	32
17						24	35
18						25	36
19						27
20						28
21						29
22						33
23						34
24
25		Total Num	Winning		Total Num	Matched In
26		Total Num	Numbers		Total Num	Group 1	Group 2
27		1	27		1	27
28		2	34		2		34
29		3	4		3		4
30		4	25		4	25
31		5	24		5	24
32		6	0		6		0
33		7	18		7	18
34		8	2		8	2
35		9	12		9	12
36		10	23		10	23
37		11	27		11	27
38		12	7		12	7
39		13	10		13	10
40		14	8		14	8
41		15	25		15	25
42		16	3		16		3
43		17	28		17	28
44		18	2		18	2
45		19	20		19		20
46		20	4		20		4
47		21	3		21		3
48		22	20		22		20
49		23	10		23	10
50		24	7		24	7
51		25	23		25	23
52		26	32		26		32
53		27	33		27	33
54		28	1		28		1
55		29	28		29	28
56		30	31		30		31
57
58
Sheet1

Please help

Thank you all.

Regards,
Moti

 

[motilulla]

Using Excel 2010
Hello,

Regards,
Moti

Using Excel 2010

Hello again,

Mainly I need to check winning numbers are in the cells C27:C56 with the Group1 & Group2 and the matching number put in to cells F27:G27 to down as per group column.

Say for example….
Cell C27 winning number is number=27 matches with Group1 & group2 as is have match with group1 place that number in group1 in cell F27

Cell C28 winning number is number=34 matches with Group1 & group2 as is have match with group2 place that number in group2 in cell G28

And continue match all 30 numbers as shown in the layout of post#1

Please help

Thank you all.

Regards,
Moti

 

[motilulla]

Hello again,

May someone have another idea to solve this task I will appreciate your input please help

Regards,
Moti

 

[motilulla]

BUMP

 

[motilulla]

BUMP

Bump

 

[motilulla]

Bump

Bump

 

[motilulla]

Bump

Hello again,

I have broken my head but could not find another way to match out winning with each group I appropriate expert idea if it could be solved

Regards,
Moti

 

[motilulla]

Hello again,

I have broken my head but could not find another way to match out winning with each group I appropriate expert idea if it could be solved

Regards,
Moti

Using Excel 2010

Hello,

I did not get VBA but reading many posts of MrExcel I got a formula which has solved my query I am placing here the answer may help others I want to thank you all who have read this question and given a time and tried to solve this query.

Seperate Match As Per Group.xlsx
	A	B	C	D	E	F	G	H	I
1
2						Group 1	Group 2
3						2	0
4						5	1
5						6	3
6						7	4
7						8	11
8						9	13
9						10	14
10						12	15
11						16	19
12						17	20
13						18	26
14						21	30
15						22	31
16						23	32
17						24	35
18						25	36
19						27
20						28
21						29
22						33
23						34
24
25		Total Num	Winning		Total Num	Matched In
26		Total Num	Numbers		Total Num	Group 1	Group 2
27		1	27		1	27
28		2	34		2	34
29		3	4		3		4
30		4	25		4	25
31		5	24		5	24
32		6	0		6		0
33		7	18		7	18
34		8	2		8	2
35		9	12		9	12
36		10	23		10	23
37		11	27		11	27
38		12	7		12	7
39		13	10		13	10
40		14	8		14	8
41		15	25		15	25
42		16	3		16		3
43		17	28		17	28
44		18	2		18	2
45		19	20		19		20
46		20	4		20		4
47		21	3		21		3
48		22	20		22		20
49		23	10		23	10
50		24	7		24	7
51		25	23		25	23
52		26	32		26		32
53		27	33		27	33
54		28	1		28		1
55		29	28		29	28
56		30	31		30		31
57
58
Sheet1

Cell Formulas
Range	Formula
F27:F56	F27	=IF(ISERROR(INDEX($F$3:$F$23,MATCH(C27,$F$3:$F$23,FALSE),1)),"",INDEX($F$3:$F$23,MATCH(C27,$F$3:$F$23,FALSE),1))
G27:G56	G27	=IF(ISERROR(INDEX($G$3:$G$23,MATCH(C27,$G$3:$G$23,FALSE),1)),"",INDEX($G$3:$G$23,MATCH(C27,$G$3:$G$23,FALSE),1))

Kind Regards,
Moti