View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
samsg
 
Posts: n/a
Default Find which values sum up another vaule, please help!


Hi, i have a list of values in a column, for example

A

5
10
3.5
...

I need to find out which values or cells sum up 8.5, the answere will
be 5 and 3.5 (A1 and A3). However my column is very large and i need to
find the solution for several values.

Any ideas are rally really apreciated, thanks a lot for the help!!!


--
samsg
------------------------------------------------------------------------
samsg's Profile: http://www.excelforum.com/member.php...o&userid=16245
View this thread: http://www.excelforum.com/showthread...hreadid=516730