![]() ![]() Just put all your values in column A, then press solve. ![]() Hope this helps lukasuk86, have a go at it. ![]() This results in simply utilizing VBA to let Solver calculate the problem a 1000 times with different targets and lucasuk86 is done. He only requires a list of 1000 products, thus 1000 prices, to be complemented with a coding. 10x seems more logical to me so that is why I arrived at this Shg: I think you're taking the problem a bit too far as far as I understand based on lucasuk86' problem statement. ![]() Shorty: don't know if there's any reasoning whatsoever to this but with regards to my solution: I figured it is most logical if the solution provides largest numbers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |