+ Reply to Thread
Results 1 to 2 of 2

How To update the month number with conditions

  1. #1
    Registered User
    Join Date
    12-04-2016
    Location
    tech
    MS-Off Ver
    2016
    Posts
    21

    How To update the month number with conditions

    Hello everyone!
    Not sure if this is possible. I have sales figures for the year and I want to show the current month sales figures by Rep.
    I have a column with the month in numerical value e.g. 9 = September, a column with the sales handler name, and a column with the sales figure.

    So I want to be able to update the month number manually each month so from 9 to 10 when October starts, and for the cell to return the sales figure for that month, for the handler the cell relates to.
    Thank's a lot.
    QC: công ty chúng tôi chuyên dịch vụ internet fpt hưng yêninternet fpt hoà bìnhinternet fpt hải phòng cho quý khách.
    Last edited by thanhvanchi; 12-15-2016 at 03:24 AM.
    Ch?c c?c bạn vui vẻ.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: How To update the month number with conditions

    upload your sample file to get clear idea.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. [SOLVED] Need to split 240 rows into an equal number, but that number may change month to month
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-17-2016, 04:15 PM
  2. Formula to give week number of a month according to date of the month
    By tukae in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2016, 11:14 PM
  3. Replies: 3
    Last Post: 07-14-2015, 12:26 PM
  4. Replies: 5
    Last Post: 05-19-2015, 05:49 AM
  5. Count number of networkdays for each month in a multi month period
    By dreddster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2013, 11:12 AM
  6. Replies: 12
    Last Post: 02-08-2013, 02:26 PM
  7. Replies: 3
    Last Post: 09-25-2007, 10:26 AM

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