Find an amont VB Code (maybe?)

[pgarcia]

Hello all,
I have an amount of $152.61 and list of amount that are "open" AR. Is there
a way to high-lit a range of dollar amounts that add up to $152.61?

Thanks

 

[dan dungan]

Hello all,
I have an amount of $152.61 and list of amount that are "open" AR. Is there
a way to high-lit a range of dollar amounts that add up to $152.61?

Thanks

Do you want edit--find?

 

[pgarcia]

Could you walk me through that? Here is the value $3,251.52 and the list of
amounts:
$370.16
$70.69
$117.05
$53.55
$61.05
$61.26
$365.13
$68.01
$113.87
$63.90
$72.76
$145.16
$60.51
$109.31
$70.50
$61.73
$161.01
$211.22
$59.57
$92.07
$166.54
$75.41
$107.07
$79.04
$115.78
$110.14
$106.39
$102.64
$346.18
$95.70
$170.77
$62.64
$113.99
$83.89
$87.64
$86.28
$102.64
$78.76
$96.64
$58.89
$132.98
$155.55
$60.97
$63.46
$58.35
$137.85
$58.49
$62.24
$121.17
$56.24
$62.24
$56.24
$172.75
$83.35
$58.35
$85.51

 

[dan dungan]

I think I misunderstood your request.

How do you know the $3,251.52 amount?

 

[pgarcia]

It's a check amont but it does not have any detail. Now, this is a short list
or amounts but there are ones longer that that. The list below has $3251.52
in it. It's around 28 items that add up to $3521.52.

 

[dan dungan]

I'll have to give it some thought. I don't have an answer right now.

 

[Gord Dibben]

Have a look here for solutions to your problem

http://tinyurl.com/cprhc7


Gord Dibben MS Excel MVP

 

[amontes]

Hello all,
I have an amount of $152.61 and list of amount that are "open" AR. Is there
a way to high-lit a range of dollar amounts that add up to $152.61?

Thanks

Check this one:
http://www.excelforum.com/excel-gen...ch-two-numbers-sum-to-a-particular-value.html