(I apologies in advance if this problem is more leaning towards a math problem than excel)
The issue has to do with an object on a line with 4 pass through stations, this object moves back and forth on the line. The major problem I'm having is figuring out how to calculate and display each distance each station is from the moving object.
What should I be looking into to solve this, and also could excel handle something like this?
(I've included a picture to better visualize the problem)
Bookmarks