Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting values from a range that equal a specific total
If I have a list of values (all different numbers) all in a column, and I
want to select values within that column that equal a specific total, is there a function in excel that will help me? -- Matty UK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting values from a range that equal a specific total
Very simple. See:
http://groups.google.com/group/micro...n&rnum=1&hl=en -- Gary's Student "Matt UK" wrote: If I have a list of values (all different numbers) all in a column, and I want to select values within that column that equal a specific total, is there a function in excel that will help me? -- Matty UK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting values from a range that equal a specific total
Thanks, but that doesnt seem at all simple. Far and above my level of
understanding I'm affraid. -- Matty UK "Gary''s Student" wrote: Very simple. See: http://groups.google.com/group/micro...n&rnum=1&hl=en -- Gary's Student "Matt UK" wrote: If I have a list of values (all different numbers) all in a column, and I want to select values within that column that equal a specific total, is there a function in excel that will help me? -- Matty UK |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting values from a range that equal a specific total
Try to Google "Solver" you may find what you are looking for
"Matt UK" wrote: If I have a list of values (all different numbers) all in a column, and I want to select values within that column that equal a specific total, is there a function in excel that will help me? -- Matty UK |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting values from a range that equal a specific total
Hi Matt UK,
for me, i have to build formulas on a one or more columns to match your need. It can help me find the combined numbers that will be summed as "equal of specific total" only if my data has the corresponding combination. You can also find links of suggestive formulas from many sites. happy holidays.. "Matt UK" wrote: If I have a list of values (all different numbers) all in a column, and I want to select values within that column that equal a specific total, is there a function in excel that will help me? -- Matty UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range of Values Returns One Result | Excel Worksheet Functions | |||
Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
selecting values from raw data | Excel Worksheet Functions | |||
Selecting specific row/column from a named range | Excel Worksheet Functions |