|Rating(1-10)||Knowledgeability = 10||Clarity of Response = 10||Politeness = 10|
|Comment||Oh my goodness, another flawless reply from Tom. Thank you, thank you, thank you. The last time I asked Tom was a couple of years ago when I hoped he would become my last resort on an issue I had with a macro. It turned out it was a piece of cake for Tom. I was relieved then, and to be honest, I was already pretty relieved now when Tom's initial response stated it wasn't really possible to make a straightaway reply because of its complexity. I resigned to my fate having to execute monthly manual calculations. Well, I thought, only a workable solution would have been the better answer, and then Tom followed it up by exactly that! The matter had haunted me for the past months. As Tom guessed correctly, the values were simplified. Column A actually displays shipment Ids, that relates to volumes in another column. Column B lists container IDs similarly relating to container load capacity in another column. Target: calculate the load factor per container. Formulas to calculate the load factor for different scenarios are not too difficult though. To extract the applicable scenario per row was, at least for me. Having received Tom's brilliant reply I feel so excited I can start or perhaps better continue fiddle things around applying this macro that worked perfectly when I tested it for a number of (extended) scenarios. I'm sure I don't yet understand all the elements of the macro you constructed, but I'm also sure that when I'm going to work with it, the understanding will gradually improve, like it did last time when you helped me out. Although I felt and feel somewhat reluctant to ask questions directly to Tom, I am also very grateful that Tom again took the time to relay such a great answer, and becoming my last resort, again... Tom, you're amazing. That your enlightening insight may shine upon us for many more years. Kind regards, Joe|
Answers by Expert:
Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]
Master of Science (MS) degree Operations Research (ORSA)
Awards and Honors
Microsoft MVP in Excel.