| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding amounts that sum to a number
I have a LARGE spreadsheet of items that I am trying to reconcile for an
entire month range. The issue that I am having - the bank statement may show one amount ($1,000), where the spreadsheet may have 4 random amounts that equal $1,000. I need to be able to find the items that equal a specified number without having to manually add up several amounts and hope for a match. Any suggestions? I have tried Conditional Formatting, Conditional Sum, and the Solver add-in. None of these will give me what I need - considering that I have about 400 items in a month. Thank you all so much for taking the time to read this! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I change column totals from number signs to amounts? | Excel Discussion (Misc queries) | |||
| Finding first number in a row | Excel Worksheet Functions | |||
| Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
| 11 $ amounts, 6 of the amounts must equal $3854.12, which 6? | Excel Discussion (Misc queries) | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
Threaded Mode
