LinkBack URL
About LinkBacks
I have data in 6 rows and 3 columns. I want to select 3 cells - 1 in each column, and not using any row more than once. In doing so, I want to select the cells that yield the largest sum possible. Any thoughts???
I have data in 6 rows and 3 columns. I want to select 3 cells - 1 in each column, and not using any row more than once. In doing so, I want to select the cells that yield the largest sum possible. Any thoughts???
well i assume it would be using max(referances)
ill knock somthing up quickly
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
combo example.xlsx
attached is what i've tried. I'm trying to maximize the result in E10, by changing B9:D9, such that B9:D9 contains only integers and no duplicates.
ty. i've tried using Solver to set the relevant cell to Max, but it never changes anything.
Last edited by amshane97; 09-06-2012 at 11:57 AM.
actully after rereading your post im not so sure. maye someone else will have an idea
why are some in brackets?
those are negative numbers. Format \ Number --> Accounting
Perhaps a solver setup like this could be used?
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks