What cells in a array equal my value?
Hi all.
I have a column of cells that have many different values.
These values are numerical costs. ie 150.54, 5,541.00 ect
I have a numerical value that comprises of several of these cells added
together. However I do not know which ones need to be added to get the value
I'm looking for... Is there a function I can use that will take all the
cells and advise which ones need to be added to equal my value? I think this
might be a tough one..
Many thanks in advance Stephen.
|