View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Elize du Preez[_2_] Elize du Preez[_2_] is offline
external usenet poster
 
Posts: 2
Default matching 24 different values to a specific value

Hello soxcpa

Please see Bernie Deitrick's reply to our problem.

Regards

Elize

" wrote:

Not quite sure what you are asking. Are you asking like in a bank
statement reconciliation..where you have a known sum which should be a
sum of two or more of the given range of possibilities? This list would
be prohibitive to list (24 options is 25! or 1.5 x10^21 options). There
are some logical ways to come up with the other list (based on no sum
can be greater than the known sum...but it would be a fairly complex
program.