Find cells that equal a given value

[Guest]

Please help me. I have looked every where but I couldn't find it. I would like to find all the cells that if you sum up them, they equal or approximately equal a given value. Per example if I write 3 and there is 1,25 in cell B4 and 1,75 in cell M45, I would like excel to give me those cells (B4-M45)
Is it possible

I will really appreciate your help. Thanks in advance.

 

[Hans]

Hi

There is no formula to calculate what you want. Besides
that, there are, in theory, so many combinations possible
that even with a complicated macro it would take a long
time to calculate what you want.

See: http://www.mrexcel.com/pc09.shtml for more info.

regards,
Hans

-----Original Message-----
Please help me. I have looked every where but I couldn't

find it. I would like to find all the cells that if you
sum up them, they equal or approximately equal a given
value. Per example if I write 3 and there is 1,25 in cell
B4 and 1,75 in cell M45, I would like excel to give me
those cells (B4-M45).