Hi,

I've got a list of numbers in the attached sheet, and am having a small issue that I was hoping you would be able to help with.

The list of numbers in column A represent the value of investment holdings.
Out of the list of numbers in column A, a number 'x' of these may sum to the figure in B1.
Unfortunately the figure in B1 may be made up of partial amounts of these figure, in which case solving this will be impossible
If this is not the case, and the figure in B1 is made up of the whole figures in column A, is there a way to find out which of these adds to this total?
Is there a function within excel, or a piece of vb code for this?

Thanks very much in advance

hriggsproblem.xls