TOM R
Well-known Member
- Joined
- Oct 7, 2006
- Messages
- 731
Hello to all,
My question, though it sounds simple. I don't think it is. I have a particular list of decimal numbers in column N3 to N83 they are also in assending order.
In cell F7 I have a number 2.0 example 2 inches.
In cells F8 thru F13 is it possible to get a list of numbers that will add up to the 2.0 inches in cells F8 thru F13 from column list in cells N3 to N83 combonation of numbers.
Or combnations. Like the largest set of numbers. Thanks for any input. Tom
Below is the list in column n3 thru n13
0.05
0.1
0.1001
0.1002
0.1003
0.1004
0.1005
0.1006
0.1007
0.1008
0.1009
0.101
0.102
0.103
0.104
0.105
0.106
0.107
0.108
0.109
0.11
0.111
0.112
0.113
0.114
0.115
0.116
0.117
0.118
0.119
0.12
0.121
0.122
0.123
0.124
0.125
0.126
0.127
0.128
0.129
0.130
0.131
0.132
0.133
0.134
0.135
0.136
0.137
0.138
0.139
0.14
0.141
0.142
0.143
0.144
0.145
0.146
0.147
0.148
0.149
0.15
0.2
0.25
0.3
0.35
0.4
0.45
0.5
0.55
0.6
0.65
0.7
0.75
0.8
0.85
0.9
0.95
1
2
3
4
My question, though it sounds simple. I don't think it is. I have a particular list of decimal numbers in column N3 to N83 they are also in assending order.
In cell F7 I have a number 2.0 example 2 inches.
In cells F8 thru F13 is it possible to get a list of numbers that will add up to the 2.0 inches in cells F8 thru F13 from column list in cells N3 to N83 combonation of numbers.
Or combnations. Like the largest set of numbers. Thanks for any input. Tom
Below is the list in column n3 thru n13
0.05
0.1
0.1001
0.1002
0.1003
0.1004
0.1005
0.1006
0.1007
0.1008
0.1009
0.101
0.102
0.103
0.104
0.105
0.106
0.107
0.108
0.109
0.11
0.111
0.112
0.113
0.114
0.115
0.116
0.117
0.118
0.119
0.12
0.121
0.122
0.123
0.124
0.125
0.126
0.127
0.128
0.129
0.130
0.131
0.132
0.133
0.134
0.135
0.136
0.137
0.138
0.139
0.14
0.141
0.142
0.143
0.144
0.145
0.146
0.147
0.148
0.149
0.15
0.2
0.25
0.3
0.35
0.4
0.45
0.5
0.55
0.6
0.65
0.7
0.75
0.8
0.85
0.9
0.95
1
2
3
4