find unknown values which adds up to some values

A

aravindhan_31

Well-known Member
Joined
Apr 11, 2006
Messages
672
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi,

I have some 100 values in Column A:like
1323
2876.02
3910.33
3360.43
2786.28
5458.01
5476.15
92.19
etc..
And in Cell B2 I have a value 49904.66 ( this is summation of some values from column A, but i dont know what are the values contributed to this)

Is there a way in VBA to check what are the values contributing to the value in B2 and highlight the cells in Column A?

please find the Cross post is here: http://www.excelforum.com/excel-prog...ml#post2125207
&
http://www.vbaexpress.com/forum/showthread.php?p=189864#post189864

Thanks n Regards
Arvind
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
Hi,
Thanks for your help:
The excel solver works for me if I have some 20 - 25 lines and it throws me an error " too many adjustable cells: for 300 line.
I tried with this code. here :
http://www.tek-tips.com/viewthread.cfm?qid=1485698
I entered A2:A300 for input & B2 for target value but I am not getting any result.
I also tried the template from
http://www.tushar-mehta.com/excel/te...olver_Template however it doest not support for 300 lines
the other threads i tired are :
http://www.mrexcel.com/forum/showthread.php?t=22298
http://www.mrexcel.com/pc09.shtml
I am not able to solve the problem.

Thanks for your help
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question
How to find a word then cross reference to see if match
Replies
0
Views
310
Patriot2879
P
B
  • Solved
need help finding cells with different values that contain the same mailing address
Replies
6
Views
621
Micron
M
E
  • Question
Search function not finding rows containing the matching value
Replies
1
Views
545
GlennUK
G
D
  • Solved
VBA code to find all cell in Col D in sheet 1 which contains cell value without match case from range A1 to A10 in Sheet 2
Replies
3
Views
377
deba2020
D
MrDB4Excel
  • Solved
Get All Instances of a Specific Value
Replies
6
Views
574
KRice
K

Forum statistics

Threads
1,216,095
Messages
6,128,795
Members
449,468
Latest member
AGreen17

Share this page

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