ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   trying to retrive number combo to = fixed amount (https://www.excelbanter.com/excel-worksheet-functions/57991-trying-retrive-number-combo-%3D-fixed-amount.html)

jsb

trying to retrive number combo to = fixed amount
 

I work in excel 2003. I have a spread sheet that has about 100 lines. I
need to find which combination of lines equal to a specific total. I
did find a very long macro, but would like to avoid as it is 6 pages
long.


--
jsb
------------------------------------------------------------------------
jsb's Profile: http://www.excelforum.com/member.php...o&userid=29221
View this thread: http://www.excelforum.com/showthread...hreadid=489458



All times are GMT +1. The time now is 09:22 AM.

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