Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find all combinations of cells that add up to certain number
Hi there,
I work in accounting and we're trying to tie numbers very often. I would like to know of a possible function or code that can output all possible combinations of cells in a column in an Excel Worksheet that add up to a certain number I enter in the adjacent column. This will help me narrow down to the possible combinations of numbers that add up to the number I am researching. Any help would greatly be appreciated. Thanks, AD! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match function...random search? | Excel Worksheet Functions | |||
Return number of cells filled | New Users to Excel | |||
How to find returns in cells | Excel Worksheet Functions | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |