how can i get a solution here ? #

sleek12

Board Regular
Joined
May 3, 2014
Messages
76
Office Version
  1. 365
Platform
  1. Windows
initial
column
3,697,770.53
đź”™
Add to this
Pick from these list only any no of combinations:-20362
74429
74429
5260 3,906,762.53
đź”™
To get this from initial column
40500
17400 There is no limit to the no. of items you can pick from list,
9500 only no duplicates allowed.
38600 If it cant be done accurately, see if an close enough solution can be provided.
37500
125640
61800
100000
50000
60000
170174
4400
550
327139
25850
22120
17400
13210
4000
181125
175349
179205
111260

I am on office 365. thank you. apologies, xl2bb could not work on my xlsx.
 
Why? What went wrong?
Screenshot 2025-02-21 151404.png
 
Upvote 0

Forum statistics

Threads
1,226,837
Messages
6,193,249
Members
453,784
Latest member
Chandni

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top