Search results

Hi SirJB7, Thanks for the tip. I don't believe I have the option to change the solving method or to ignore integer constraints. I know that Frontline and Excel made some serious changes to solver for Excel 2010 and beyond, so perhaps that was part of the upgrade. Which version are you using? Nat

Hi Narayan, I could type it out on my phone, but the file was on my computer at work. Here it is now. Nat https://www.dropbox.com/sh/691blh8b0ocvtew/m_SdbM_EUS

Hello all, I've recently started exploring solver, but I've hit a wall with using it on this particular problem. I am trying to optimize the allocation of students to courses in a school based on a number of parameters and constraints. I built out a cost function to use in simulated annealing...

Good day all, I'm wondering if anyone has experience linking Excel workbooks across DropBox folders. My employer recently switched from a shared drive to DropBox and we've been dealing with all sorts of issues as people customize their folder structures. For example, I might link to a document...

Hi Deb, That works just fine. I still wish I understood why I can't control the sort area, but this solution is good enough for now. Thanks! Nat

Hi Deb, Thank you for the warm welcome! Unfortunately, neither of your suggestions seems to have helped. My headers are in cells A4:H4. My data are in cells A5:H19. My calculations are in cells C20:H21, with descriptions of the calculations in B20:B21. Even though I highlight only cells A4:H19...

I'm having a slightly frustrating issue with autofilter. My spreadsheet includes headers, about twenty rows of data below those headers, and then two rows below the data presenting averages of each column. I'd like to use the autofilter to sort by value for each row, but it keeps pulling my...