ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Return values from a list that sum to a known value (https://www.excelbanter.com/excel-discussion-misc-queries/264655-return-values-list-sum-known-value.html)

lmattern

Return values from a list that sum to a known value
 
Is it possible to return values from a list that sum to a known product, for
example:

10

1
2
7
6
9

The returned list would be 9,1 and 7,2,1.

Thanks.


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com