View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Isolate UNIQUE combination of Z cells from a range N that adds up

I have a range of N cells, all in one column and all unique numbers. I also
know that Z cells from this range adds up to a number R. This combination of
Z cells is unique, i.e. there is only one combination of Z cells that adds up
to R.

How can I have these Z cells shown in a separate column? In other words,
how can I isolate them?

Thanks for any help!!!