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?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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>
 
Upvote 0
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 ?
 
Upvote 0
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
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,218
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