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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find all combinations of cells that add up to certain number
Please do not post to more than one group in separate posts.
Your post has been answered in another group -- Kind regards, Niek Otten "AD" wrote in message ... 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! |
Reply |
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) |