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,077
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,670
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,078,461
Messages
5,340,440
Members
399,375
Latest member
alwayssunny

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top