which cells build the sum?

K_A_R_M_O

Board Regular
Joined
Dec 4, 2009
Messages
59
Hello Dear Community!
I hope you can help me solve this problem. I have the following table(see below). I know that some of the cells(here in column B) make up a sum of 16.745.187,38, but i know neither which ones these are nor of how many cells the sum is composed of. I wonder, if there is any formula or VBA code, which would somehow point out those numbers(cells), which make this 16.745.187,38. I guess it is not so easy, because excel would have to check all possible combinations. I hope you smartest people in the world (as excelsfun on youtube described you:)can help me, because i face this problem much too often. Thanks a lot in advance!

<TABLE style="WIDTH: 277pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=369 border=0><COLGROUP><COL style="WIDTH: 153pt; mso-width-source: userset; mso-width-alt: 7460" width=204><COL style="WIDTH: 124pt; mso-width-source: userset; mso-width-alt: 6034" width=165><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl95 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 153pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=204 height=21>Kontonummer (PCA)</TD><TD class=xl93 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776 0.5pt solid; BORDER-LEFT: #4d6776 0.5pt solid; WIDTH: 124pt; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent" width=165>01-10 2009</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776 0.5pt solid; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andere Ben.Entgelte</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-375.939,59</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Erl.Konzessionen</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-452.007,64</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Erl.sonst.Lstg.Verr.</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-549.008,34</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Bandbreite</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-6.065.689,33</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Telefon int.</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-5.469.484,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Datenpakete</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-1.610.292,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Videoanlagen</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-1.211.585,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Telefon ext.</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-266.413,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Betriebsanw.</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-55.672,12</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml.VT Routerdienst</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-598.194,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml.VT Funkeinrichtu</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-598.992,45</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Uml. VT Brandmeldean</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-1.169.814,20</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Servicetechniker</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-86.448,50</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Facharbeiter</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-399.709,66</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Lehrling</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-4.176,90</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Handyfunkgebühren</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-881.575,83</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Datend.u.Mietleitung</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-25.039,94</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl96 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Tel.gebühr Telekom</TD><TD class=xl98 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-282.401,28</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT SW-Installation</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-408,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Leihgerät Handy</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-2.157,59</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Telefon</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">44.048,19</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Einzelgesprächsna</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-29,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Brandmeldea.NEU</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-13.590,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Brandmledeanl.ÄND</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-49.000,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Bandbreite Neu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-67.549,16</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Telefon int. Neu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-28.971,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Datenpaket Neu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-13.005,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Video Neu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-14.630,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Telefon ext. Neu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-61.705,23</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Autoeinbau Handy</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-630,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Bandbreite Änd.</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-727,16</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Telefon int. Änd.</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-25.375,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT-Telefon ext. Änd.</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-783,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Funkgerät neu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-150,00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl97 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776 0.5pt solid; BORDER-BOTTOM: #4d6776 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>VT Neueinrichtung Zu</TD><TD class=xl99 style="BORDER-RIGHT: #4d6776 0.5pt solid; BORDER-TOP: #4d6776; BORDER-LEFT: #4d6776; BORDER-BOTTOM: #4d6776 0.5pt solid; BACKGROUND-COLOR: transparent">-90,00</TD></TR></TBODY></TABLE>
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Many, many thanks to your warm welcome-greetings and especially for your prompt answer. I have already tried both, the VBA as well as the solver. I got only very approximate results with the VBA code, with solver it was more exact. I guess i need to play with it a little:) Thanks once more!
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

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