batches

I'm trying to teach myself to use Excel solver to take the work out of manually calculating minor production details. but am struggling. Say I have a make to order job with 7 sizes and I want to run them on 5 machines. I would like the solver to find the optimal order to run them given 5...

I tried to do a 1,000,000 record pull which took quite a while. when the process finished I got this error: expression.error: evaluation resulted in a stack overflow and cannot continue. However, when I do small batches the data comes over fine. Is there a way to get around this error? Much...

G'day! I currently have : =SUM(IF(FREQUENCY(A8:A1000,A8:A1000)>0,1)) It batches column A with re-occurring values and gives the number of batches this works great! However, I now want to look at column H:H and see how many batches from A:A have the value "MG" in column B. See example below...

Hello all, long time reader, first time poster. I have been slowly, but surely, upgrading the sheets we use at work. These little upgrades have simplified things and removed many issues of error. Now, I want to add one for laziness. A have a batch of cells A2:U20 (for example) that we fill...

Hi all, I have proudly created my first macro (albeit using the Record feature in Excel). I have a master data with about 100,000 rows of data and about 50 columns. The master data sheet contains account information and related owners. The objective is to split this data by batches and send...

Hello everyone. I have a list of "numbers" which consists of three letters followed by six numbers. Batches will belong to different clients. E.g. ABC100000 to ABC110000 belongs to client A, ABC110001 to ABC120000 belongs to client B etc. I would really like members of staff to enter a number...