Results 1 to 3 of 3

Thread: Using Icon set for Analysis

  1. #1
    Seeker gillani77's Avatar
    Join Date
    Jun 2014
    Posts
    14
    Articles
    0
    Excel Version
    office2013

    Using Icon set for Analysis



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi ,
    I want to show trend of each customer ( going upward or downward).

    1. I have number of orders placed in month of Jan by each customer in column "B"
    2. I have number of orders placed by same customer in month of Jun in column "L"
    I want to analyse following in column "N".
    1. If customer has made more orders in Jun that jan then his trend is upward and it should be shown with upward arrow

    Or
    2. If customer has made less orders in Jun that jan then his trend is downward and it should be shown with downward arrow

    Can some body help me in making this report. I have attached my sheet for your consideration pls.
    Attached Files Attached Files

  2. #2

    Arrow

    Have a look at this:

    Analysis_SB.xls
    Cheers
    Sumit Bansal
    Excel MVP (2014-15)
    Founder, Trump Excel

  3. #3
    Seeker gillani77's Avatar
    Join Date
    Jun 2014
    Posts
    14
    Articles
    0
    Excel Version
    office2013
    Thanks a lot. Sumit.

Posting Permissions

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