brandonmcg
New Member
- Joined
- Jan 14, 2009
- Messages
- 43
- Office Version
- 2016
- Platform
- Windows
If I enter a dollar amount (will use $1,513.30 for this example) I need an x or other identifier to show me which amounts combined match that dollar amount. What would a formula look like and maybe even a MACO?
[TABLE="width: 227"]
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="223" style="width: 167pt; mso-width-source: userset; mso-width-alt: 8155;"> <tbody>[TR]
[TD="width: 80, bgcolor: transparent"]Amount[/TD]
[TD="width: 223, bgcolor: transparent"]Looking For Match To This Amount
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]$1,513.30
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-$36.15[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$0.01[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$1.06[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$11.22[/TD]
[TD="bgcolor: transparent"]x[/TD]
[/TR]
[TR]
[TD]$1.35[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$1.57[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$5.66[/TD]
[TD="bgcolor: transparent"]x[/TD]
[/TR]
[TR]
[TD]$4.12[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$7.85[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$383.55[/TD]
[TD="bgcolor: transparent"]x
[/TD]
[/TR]
[TR]
[TD]$1,112.87[/TD]
[TD="bgcolor: transparent"]x[/TD]
[/TR]
[TR]
[TD]$1,380.97[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 227"]
<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="223" style="width: 167pt; mso-width-source: userset; mso-width-alt: 8155;"> <tbody>[TR]
[TD="width: 80, bgcolor: transparent"]Amount[/TD]
[TD="width: 223, bgcolor: transparent"]Looking For Match To This Amount
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]$1,513.30
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-$36.15[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$0.01[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$1.06[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$11.22[/TD]
[TD="bgcolor: transparent"]x[/TD]
[/TR]
[TR]
[TD]$1.35[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$1.57[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$5.66[/TD]
[TD="bgcolor: transparent"]x[/TD]
[/TR]
[TR]
[TD]$4.12[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$7.85[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD]$383.55[/TD]
[TD="bgcolor: transparent"]x
[/TD]
[/TR]
[TR]
[TD]$1,112.87[/TD]
[TD="bgcolor: transparent"]x[/TD]
[/TR]
[TR]
[TD]$1,380.97[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]