Search results

I understand. This is just a part of the data. I am trying to combine two different data sheets together. I have Items which have multiple values and then those multiple values have multiple values of their own. I am trying to compile all of it together for better visibility. I will try the...

Luke M, Thanks for the reply. I read through your link and I could see that your formula returns multiple values. However I am still not sure how to run it for multiple items, say 50 or 100? For example in your sheet there are Fruits, Soft drinks, Juices, etc and they all have multiple types...

Hi There, I am trying to perform a vlookup type of action on the items in a column, the only thing is that I am trying to lookup multiple values for each of the items from an array. Some items could return 3 values, some can 5, some can 10, etc. I counted the number of values each item...

Hi SirJB7, I took the entire file, the posted data is just part of it. cheers Sameer

Thanks SirJB7. Chandoo, I ran the solver on the file using all three solving methods, Simplex LP, GRG Nonlinear and Evolutionary. Simplex LP always selected the top 8 (8 Locations - 28 Jobs) and GRG Non linear always selected the bottom 8 (8 Locations - 22 Jobs). However Evolutionary...

Thanks SirJB7. Although I tried Chandoo's workbook and populated it with the entire data and modified the tables and formulas accordingly and it seems to be working. I understand Narayan's point that it could be improved upon but it still gives pretty good results. Thanks a lot Chandoo! I am...

SirJB7, I just tried your sheet, it only gives me top 5 locations with maximum number of jobs associated with them. However it does not tell me how many of those job would I be able to complete through those 5 locations. I think its similar to running a pivot on the data and getting the number...

SirJB7, Narayank991, Chandoo, Thank you all for replying! That is right, I am looking for the best possible set of 4 or 5 (preferably 5) locations that would be able to complete maximum jobs, while some of the jobs associated with these locations are left uncompleted. However I did have...

Running a pivot table tells me how many jobs are associated with a particular location. But like I said, those jobs could require more locations to be completed and those locations again might have more jobs associated with them and so on. Running the pivot gives me the details of 50+...

Hi there, My data is in the following format: Job# Location 1002612 L610 1002619 L610 1002622 L610 1003360 L560 1003360 L871 1003470 L2925 1003470 L244 1003470 L120 1003498 L2925 1003498 L244 1003498 L120 1003523 L2925 1003523 L244 1003523 L120 1003527 L140 1003537 L3545...

I can't see anyway to attach it over here.

Pivot might not work as I am looking up the same value in multiple columns and in different formats. I am not able to put it in the right way, is there a way I could send you an example of the file?

I have a follow up question though. Below is the example: 1 ColA ColB ColC ColD ColE ColF 2 ABC X ABB 3 ABC X1 ABB ABC 2 4 ABD X1 ABB ABC 2 X 5 ABD X2 ABB ABC 2 X1 6 ABD X3 ABB ABD 3 7 ABE X ABB ABD 3...

Thanks a lot Luke! That is exactly what I was looking for.

Hi there, Below is an example of the file I am working on. I want to add empty rows corresponding to the value in Col3, so 2 empty rows below ABC and 3 empty rows below ABD and so on. Col1 Col2 Col3 ABB ABB ABC 2 ABB ABD 3 Can anyone help with that?