Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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.worksheet.functions
|
|||
|
|||
![]()
Do NOT post the same question to more than one newsgroup!
Do a Google search & you will find several threads on this subject http://groups.google.com/advanced_gr..._ugroup=*excel "AD" wrote: 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 | |
|
|
![]() |
||||
Thread | Forum | |||
find all combinations of cells that add up to certain number | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
Return number of cells filled | New Users to Excel | |||
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) |