+ Reply to Thread
Results 1 to 4 of 4

Formula to show Direction of Travel with an Arrow

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    20

    Formula to show Direction of Travel with an Arrow

    Hi

    I am using Excel 2010 and am struggling with a formula for this...

    I have a spreadsheet (attached below) which has some basic conditional formatting (yes/green & no/red) when a target is acheived. In addition to this I would like the sheet to populate an arrow in the adjacent cell to show the direction of travel of the objective that month compared with the previous month. I have simply used the wingdings 3 front to populate this in the spreadsheet to show what I am after.

    - If the objective is consistent with the previous month (yes-yes or no-no) then it should show a forwards arrow.
    - If the objective is worse that the previous month (yes-no) then it should show a down arrow.
    - If the objective is an improvement on the previous month (no-yes) then it should show an up arrow.

    I would really appreciate your help in resolving this one, with thanks in advance, Paul.

    PM Direction of Travel.xls

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formula to show Direction of Travel with an Arrow

    Using your Wingdings approach, see the blue cells in the attached.

    Obviously this does not work for column C as there is no previous month shown to compare column B against.

    BSB
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-21-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Formula to show Direction of Travel with an Arrow

    Perfect, thank you BadlySpelledBuoy, I have added to your reputation and will mark the post as solved.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formula to show Direction of Travel with an Arrow

    Happy to help.
    Thanks for the rep point.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. what formula i can use for mt travel agency DB.
    By SalgotraSonia in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2015, 03:40 AM
  2. Multiple Wind Speed and Direction arrow plots on an xy scatter
    By surfmuncher in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 06-16-2014, 10:17 PM
  3. Formula using arrow icons to show trend
    By TeoSR in forum Excel General
    Replies: 0
    Last Post: 01-30-2013, 07:06 AM
  4. Formula using arrow icons to show trend
    By casdaq in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-30-2012, 05:04 PM
  5. Show Drop Down Arrow
    By travelersway in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 10-17-2005, 08:05 PM
  6. how do i plot a rose diagram to show frequency of wind direction
    By kathryn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2005, 06:06 PM

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