Vba?

hurstg01

New Member
Joined
Aug 13, 2015
Messages
11
I have a column of number values and need to find a give amount which could be a multiple of 1 or more of those numbers. Is this possible in excel?
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,046
I would need more details.
You said:
I have a column of number values

You did not say what column

You said:
need to find a give amount

What do we do if we find it?
<strike>
</strike>
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,661
Hello,

If your question is related to Accounting Reconciliation ...

You are probably looking for " which numbers sum up to a given Total " ...

Is that right ?
 

hurstg01

New Member
Joined
Aug 13, 2015
Messages
11
I would need more details.
You said:
I have a column of number values

You did not say what column

You said:
need to find a give amount

What do we do if we find it?
<strike>
</strike>

Hello,

If your question is related to Accounting Reconciliation ...

You are probably looking for " which numbers sum up to a given Total " ...

Is that right ?
Yes, James006 that's what I 'm after
 

Anthony47

Well-known Member
Joined
Mar 29, 2006
Messages
1,481
You may want to give a look to this workbook:
https://www.dropbox.com/s/g7jyqglhsllvld3/CercaCombinaz_V1-308.xlsm?dl=0

Instruction are the following:
-Insert in sheet LAVORO, in B2 and below the list of values. Max 30 values
-Insert in sheet LAVORO- A1 thempty it will be 0.001
-All value must be positive
-Insert in sheet LAVORO - A4 the "total" to be searched

-Start macro CercaCombo308 via the button marked AVVIA; a userform will be shown
---Optionally modify the "Time Out" (default = 1 minut)
---Press CERCA

Possible combinations will be shown fron column C on
You may get the status of the search using button Status, or stop the search using button Stop
A message will confirm end of search

Maximum 999 results (250 in XL2003) will be searched

At the end, if you select one of the X on row 1 then the corresponding addends in column B will be highlighted

Bye
 
Last edited:

Forum statistics

Threads
1,077,827
Messages
5,336,612
Members
399,092
Latest member
jbwatkins

Some videos you may like

This Week's Hot Topics

Top