Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate various cells to acheive a specific value
Hello,
I am trying to identify two cells within a column that total a specific amount. For example: ColA 546 9732 654 6548 687 9871 I need to find the two (or more cells in some cases) that would create the total of 10,525. For my current task, I have over 100 rows of data and I know two cells equal a specific amount, but I do not know which two. Any help, or assistance given would be greatly appreciated! Jennifer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to calculate Sundays between a specific date & today () | Excel Discussion (Misc queries) | |||
how calculate the date someone had to be born to have a specific a | Excel Discussion (Misc queries) | |||
Calculate max value in specific range | Excel Discussion (Misc queries) | |||
Only calculate specific worksheet automatically? | Excel Worksheet Functions | |||
How do I calculate specific data across worksheets? | Excel Worksheet Functions |