I don't usually run into roadblocks when it comes to excel, but am hoping someone here may be able to help with something I have been scratching my head on for a couple days. Would prefer to avoid a VBA solution.
essentially its a network diagram, where I have receipt and delivery points, and am trying to calculate the values of the arc between points along the system.
failed to handle it with a sumproduct, or an index/match and am hitting a roadblock.
here is an example of what I am hoping for:
http://photoshare.shaw.ca/view/28758...-60002/287583/