Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers
is there a way to set up a group of numbers and then of that group of
numbers get excel to figure which ones will give a total sum when asked? such as: I have a group, sayyy 10, 17, 5, 9, 20, 16. I want to know which numbers in that group would add up to 56 (10,17,9,20). Any help here? not sure how posts are done here.. I will be looking or an answer could be emailed to thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers
checkout:
http://www.tushar-mehta.com/excel/te.../match_values/ -- Gary''s Student - gsnu200858 "Flya172" wrote: is there a way to set up a group of numbers and then of that group of numbers get excel to figure which ones will give a total sum when asked? such as: I have a group, sayyy 10, 17, 5, 9, 20, 16. I want to know which numbers in that group would add up to 56 (10,17,9,20). Any help here? not sure how posts are done here.. I will be looking or an answer could be emailed to thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |