Results 1 to 3 of 3

How to create a Drill down filter/formula

Threaded View

  1. #3
    Registered User
    Join Date
    05-19-2008
    Posts
    10

    reply with attachement

    I am a district manager for a team of people that merchandise retail stores. We pay mileage and travel time. So as you can see in the attachement I have worked out all possible senerios of what store my employee can go to.

    What I am wanting is a place where I can enter store 1 (say 1003) and then enter store 2 (say 1004) and it will sort through this list and give me the distance and time of travel....

    If this can go up to seven locations would be great.

    See the issue is that it will have to sort through the list on its own and add the totals together.

    I hope this is a good enough explanation.


    I have boxed off an example of what I need it to do. The yellow area is where the formula would have to be...

    Any suggestions would be great...If I am looking at this wrong.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1