| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find terms that sum to chosen total among a column of numbers?
Can you highlight a column of numbers and tell excel to find those numbers in
the column that sum to a number that you choose? And if there are no numbers in the column that sum to that given total, it will indicate such? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find terms that sum to chosen total among a column of numbers?
see:
http://www.tushar-mehta.com/excel/te...ues/index.html -- Gary''s Student - gsnu200779 "lstutchman" wrote: Can you highlight a column of numbers and tell excel to find those numbers in the column that sum to a number that you choose? And if there are no numbers in the column that sum to that given total, it will indicate such? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find terms that sum to chosen total among a column of numbers?
Hello,
We had a similar question some time ago: http://groups.google.de/group/micros...+durchsuch en Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find a special total from a combination of numbers | Excel Worksheet Functions | |||
| Can excel find a sequence of numbers from a known total? | Excel Discussion (Misc queries) | |||
| Can excel find a sequence of numbers from a known total? | Excel Worksheet Functions | |||
| find numbers in a list which sum a total | Excel Worksheet Functions | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
Linear Mode
