Return values from a list that sum to a known value

• Tweet
• Follow

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. 0 Reply Utf 5/27/2010 10:20:02 PM	microsoft.public.excel.misc 79177 articles. 66 followers. 0 Replies 278 Views (page loaded in 0.09 seconds) Need help with a project sheet, need date to show/not show based o 4 126 Utf Press Enter and Move Back to Column A Automatically 3 462 Utf Why did auto calculate suddenly change to manual calcu... 4 489 Utf Converting Vertical Data into Horizontal Data 1 488 Utf Print a 2-sided document in Excel for a 3-ring binder? 3 202 Utf Formulas using time and dates 3 129 Utf Filter with criteria! 1 157 Utf Matching letters and then counting 2 155 Utf Hyperlink to move the cursor to the top of the frozen panes 3 148 Utf Summary of data using array formula 1 143 Utf 8/18/2012 1:30:30 AM
Reply: