View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AD AD is offline
external usenet poster
 
Posts: 9
Default 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!