August Challenge of the Month Discussion

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Re: Help

Hi ,

I'm working in the bookkeeping and i have this problem to solve every day.

Can some body explaine how to put this macro in an excel file, or send me a excel ark with the macro in place.
Click to expand...

If you want the macro-workbook just pm me
 
I PM'd IOANNIS a few weeks back and still have not heard from him. However I would really like to be able to put this macro to work. Would anyone mind PMing me with a link to download this workbook or perhaps we can exchange emails?

Thank you!
TS
 
Can anyone supply me with a walkthrough for Ioannis solution. This could really help in work but am only just beginning to ctreate an understanding of VB.


Thanks

Edited by Moderator to remove email address. Refer point 19 of the Posting Rules
 
Last edited by a moderator:
Can anyone supply me with a walkthrough for Ioannis solution. This could really help in work.

Edited by Moderator to remove email address. Refer point 19 of the Posting Rules
 
Last edited by a moderator:
Juan Pablo González said:
I used a Solver model for this:


******** ******************** ************************************************************************><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" bgColor=#0c266b colSpan=22><TABLE border=0 width="100%" align=center><TBODY><TR><TD align=left>Microsoft Excel - Libro1</TD><TD style="FONT-FAMILY: caption; COLOR: #ffffff; FONT-SIZE: 9pt" align=right>___Running: xl2000 : OS = Windows NT 4 </TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px; BORDER-RIGHT: #000000 0.5pt solid" bgColor=#d4d0c8 colSpan=22><TABLE border=0 width="100%" align=center VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-FAMILY: caption; COLOR: #000000; FONT-SIZE: 10pt">(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout</TD><TD vAlign=center align=right><FORM name=formCb605117><INPUT value="Copy Formula" type=button name=btCb942116 *******='window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);'></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" bgColor=white colSpan=22><TABLE border=0><TBODY><TR><FORM name=formFb202339><TD style="WIDTH: 60px" bgColor=white align=middle><SELECT onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name=sltNb447362><OPTION selected value==A2-SUMPRODUCT($B$1:$Q$1,B2:Q2)>R2<OPTION value==SUM(B2:H2)>S2<OPTION value==SUM(I2:Q2)>T2<OPTION value==S2+T2>U2<OPTION value==A3-SUMPRODUCT($B$1:$Q$1,B3:Q3)>R3<OPTION value==SUM(B3:H3)>S3<OPTION value==SUM(I3:Q3)>T3<OPTION value==S3+T3>U3</OPTION></SELECT></TD><TD bgColor=#d4d0c8 width="3%" align=right>=</TD><TD bgColor=white align=left><INPUT value==A2-SUMPRODUCT($B$1:$Q$1,B2:Q2) size=80 name=txbFb150492></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" width="2%" align=middle>

</TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>A</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>B</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>C</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>D</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>E</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>F</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>G</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>H</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>I</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>J</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>K</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>L</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>M</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>N</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>O</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>P</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>Q</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>R</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>S</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>T</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>U</CENTER></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>1</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: left; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffff99; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">Salary</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">500</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">200</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">100</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">50</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">20</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">10</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">5</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">5</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">0.5</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">0.2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">0.1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">0.05</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">0.02</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">0.01</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: left; BACKGROUND-COLOR: #ff99cc; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">Difference</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: left; BACKGROUND-COLOR: #99ccff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">Total*banknotes</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: left; BACKGROUND-COLOR: #99ccff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #d4d0c8 0.5pt solid">Total*coins</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: left; BACKGROUND-COLOR: #99ccff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-TOP: #000000 0.5pt solid; FONT-WEIGHT: bold; BORDER-RIGHT: #000000 0.5pt solid">Total</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>2</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">440.21</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">4</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">6</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>3</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">410.86</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">2</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">1</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">0</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">3</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #d4d0c8 0.5pt solid">5</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-RIGHT: #000000 0.5pt solid">8</TD></TR><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" colSpan=22><TABLE width="100%" align=left VALIGN="TOP"><TBODY><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; WIDTH: 120pt; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=left>Hoja1</TD><TD>*</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>

I solved each row at a time, but, that can be changed. Solver model:

Target cell: U2
Minimum cell value

Changing cells: B2:Q2
Restrictions

B2:Q2 = Integer
R2 = 0

And in "Options", I checked "Assume non negatives". Using more restrictions you can answer all your questions...
Click to expand...


Hi ,

I tried solver but I don't get the same answer as you. Is there any additional criteria’s I need to add?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

<TABLE style="WIDTH: 503pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=667 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 1024" span=3 width=28><COL style="WIDTH: 16pt; mso-width-source: userset; mso-width-alt: 768" span=3 width=21><COL style="WIDTH: 11pt; mso-width-source: userset; mso-width-alt: 512" span=4 width=14><COL style="WIDTH: 19pt; mso-width-source: userset; mso-width-alt: 914" span=3 width=25><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1170" span=2 width=32><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1426" width=39><TBODY><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #666699 1pt solid; BACKGROUND-COLOR: #ffff99; WIDTH: 48pt; HEIGHT: 26.25pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl24 height=35 width=64>Salary</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #666699 1pt solid; BACKGROUND-COLOR: #ccffcc; WIDTH: 21pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" id=td_post_95016 class=xl29 width=28 x:num>500</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 21pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=28 x:num>200</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 21pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=28 x:num>100</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 16pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=21 x:num>50</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 16pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=21 x:num>20</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 16pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=21 x:num>10</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 11pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=14 x:num>5</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 11pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=14 x:num>5</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 11pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=14 x:num>2</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 11pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=14 x:num>1</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 19pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=25 x:num="0.5">1</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 19pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=25 x:num="0.2">0</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 19pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=25 x:num="0.1">0</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 26pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=35 x:num>0.05</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 24pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl30 width=32 x:num="0.02">0</TD><TD style="BORDER-BOTTOM: #666699 1pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ccffcc; WIDTH: 24pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: #666699 1pt solid" class=xl31 width=32 x:num="0.01">0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #ff99cc; WIDTH: 48pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl25 width=64>Difference</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #99ccff; WIDTH: 45pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=60>Total*banknotes</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #99ccff; WIDTH: 47pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=63>Total*coins</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: #99ccff; WIDTH: 29pt; BORDER-TOP: #666699 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl27 width=39>Total</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl22 height=17 width=64 x:num>440.21</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 21pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=28 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 21pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=28 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 21pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=28 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 16pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=21 x:num>7</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 16pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=21 x:num>3</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 16pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=21 x:num>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 19pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=25 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 19pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=25 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 19pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=25 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 26pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=35 x:num>3</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 24pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=32 x:num>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 24pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=32 x:num>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=64 x:num x:fmla="=A2-SUMPRODUCT($B$1:$Q$1,B2:Q2)">0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 45pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=60 x:num>4</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=63 x:num>2</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #666699 1pt solid" class=xl28 width=39 x:num x:fmla="=S2+T2">6</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl22 height=17 width=64 x:num>410.86</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 21pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=28 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 21pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=28 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 21pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=28 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 16pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=21 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 16pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=21 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 16pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=21 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 11pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=14 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 19pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=25 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 19pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=25 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 19pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=25 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 26pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=35 x:num>8217</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 24pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=32 x:num>0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 24pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=32 x:num>1</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=64 x:num x:fmla="=A3-SUMPRODUCT($B$1:$Q$1,B3:Q3)">0</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 45pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=60 x:num>3</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 47pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: silver 0.5pt solid" class=xl23 width=63 x:num>5</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: #ebe9ed; BACKGROUND-COLOR: white; WIDTH: 29pt; BORDER-TOP: #ebe9ed; BORDER-RIGHT: #666699 1pt solid" class=xl28 width=39 x:num x:fmla="=S3+T3">8</TD></TR></TBODY></TABLE>
Biz
 
What cell address do I put my total invoice payment received?
What column do I put my details of individual amounts due?

Thanks for your usual support
 
I've noticed a few people were looking for the workbook from IOANNIS.
Here is a walkthrough.

1. Create a New Sheet
2. In Column B paste the Values (Your own or from the challenge)
3. Column A have an incrementing count (1,2,3,4 etc)
4. Leave C/D blank
5. the Range E1 to F20 should look like this

Excel Workbook
EF
1Total Invoices54
2CHECK* * * * * * * * * * * * * 4,556.92
3MAX_SUM_NUMBERS21
4MAX_CHECK_No53
5CURRENT SHEET_SOLUTIONS0
6TOTAL_SOLUTIONS_FOUND0
7TOTAL SHEET SOLUTIONS0
8MAX_RESUME_No0
9LAST SOLUTION FOUND or *COMBINATION
100*
11CHECKED COMBINATIONS1
12TOTAL_COMBINATIONS9.0072E+15
13COMBINATION'S % DONE1.11022E-14
14MACRO'S TIME START*
15LAST FOUND SOLUTION'S TIME*
16ELAPSED TIME12:00:00 AM
17REMAIN TIME12:00:00 AM
18LAST RESUME TIME12:00:00 AM
19TOTAL *CALC TIME12:00:00 AM
20SOLUTION'S SPEED/HOUR#DIV/0!
Sheet1

6. Add 2 Modules (Module1 and Module2)
7. Copy the appropriate code to the appropriate module
8. IMPORTANT: Make sure you don't have Option Explicit in either module.
9. Run the macro "Challenge"
 
You must log in or register to reply here.

Forum statistics

Threads
1,223,743
Messages
6,174,244
Members
452,553
Latest member
red83

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