Find index or lexicographic order numbers + combinations and sum of that.

[Kishan]

Using Excel 2000
Hi,
First question, 5_50 lottery numbers range E3:I9 I want a formula which can give me an index or lexicographic order numbers. As shown in column J?

Kishan Index.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1										lexicographic Or
2					Num-1	Num-2	Num-3	Num-4	Num-5	Index nº
3					1	2	3	4	5	1
4					1	2	3	14	25	43.220
5					1	2	4	24	29	107.137
6					1	2	5	31	46	1.249.169
7					1	2	5	35	47	1.417.135
8					5	17	22	24	32	180.221
9					46	47	48	49	50	2.118.760
10
11
12
13
14
Sheet10

Second question, is once I have the index or lexicographic order numbers as sown below in range E6:E9 it can give me combinations as shown. In the range F3:J9

Kishan Index.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1					lexicographic Or
2					Index nº	Num-1	Num-2	Num-3	Num-4	Num-5
3					1	1	2	3	4	5
4					43.220	1	2	3	14	25
5					107.137	1	2	4	24	29
6					1.249.169	1	2	5	31	46
7					1.417.135	1	2	5	35	47
8					180.221	5	17	22	24	32
9					2.118.760	46	47	48	49	50
10
11
12
Sheet12

Third question, in case if possible I do not want to generate combination from index or lexicographic order numbers only just with “index or lexicographic order numbers” can I get sum? As shown index number in E3:E9 & sum in F3:F9?

Kishan Index.xlsx
	A	B	C	D	E	F	G
1					lexicographic Or
2					Index nº	Sum
3					1	1
4					43.220	45
5					107.137	60
6					1.249.169	85
7					1.417.135	90
8					180.221	100
9					2.118.760	240
10
11
12
Sheet13

Cell Formulas
Range	Formula
F3	F3	=IF(SUM(A3:E3)=0,"",SUM(A3:E3))

Please I need some "Formula or VBA" solution for my these 3 problems

Thank you in advance

Regards,
Kishan

 

[Kishan]

BUMP ....

 

[Kishan]

BUMP ....

BUMP

 

[Kishan]

BUMP

 

[Kishan]

Please suggest I have a question, does I need to split 3 queries separately?

Regards,
Kishan

 

[Kishan]

@Peter_SSs, Please I need your advice I think I have made a mistake placing 3 question in one thread, does it is possible to delete the thread otherwise if I place a new individually query I would be duplicating the question is it correct?

Please suggest what I should do.

Regards,
Kishan

 

[Kishan]

@Peter_SSs, Please I need your advice I think I have made a mistake placing 3 question in one thread, does it is possible to delete the thread otherwise if I place a new individually query I would be duplicating the question is it correct?

Please suggest what I should do.

Regards,
Kishan

Please Help

 

[Kishan]

Please Help

Bump