| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| Can you Find and Replace values with in a formula? | Excel Discussion (Misc queries) | |||
| How do I find the two lowest values in a range? | Excel Worksheet Functions | |||
| in excel, how do I find which values doesn't have a pair? | Excel Discussion (Misc queries) | |||
| To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions | |||
Linear Mode
