I have an array of data A1:K43 (row 1 has the headers). Listed in A2:A43 are the warehouse #'s (different city for each). Each subsequent column (B-K) represents the annual shipping expense from that city to the warehouse city (on that row). (E.g. B2 would be from Dallas (B1) to warehouse 1 (A2). This repeats and column C is Atlanta e etc.
I am looking for a solution (in this example assumes I want the two best only) that would solve for the best two locations to ship from when two locations are used. This is typically a different solution than when using the small 1, small 2 formulas.
Is there a non-vba way to solve for this? If not, is there a vba solution that someone has they could share?
Any help is greatly appreciated!
I am looking for a solution (in this example assumes I want the two best only) that would solve for the best two locations to ship from when two locations are used. This is typically a different solution than when using the small 1, small 2 formulas.
Is there a non-vba way to solve for this? If not, is there a vba solution that someone has they could share?
Any help is greatly appreciated!