+ Reply to Thread
Results 1 to 5 of 5

Start counting depends on the value

  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Start counting depends on the value

    I have 3 subjects
    MATH - Start with 9
    SCIENCE - Start with 11
    ENGLISH - Start with 5
    on formula when the value is math it will start the counting into 9. I upload image for the expected result. Thank you so much in advance.

    Expected Result.PNG
    Attached Files Attached Files
    Last edited by jasond1992; 05-10-2021 at 10:52 AM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Start counting depends on the value

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Start counting depends on the value

    Create "LOOKUP" table as in E2:F4

    MATH 9
    SCIENCE 11
    ENGLISH 5

    in B2

    =IF(COUNTIF($A$2:$A2,$A2)=1,VLOOKUP($A2,$E$2:$F$4,2,FALSE),$B1+1)

    OR

    =IF(COUNTIF($A$2:$A2,$A2)=1,LOOKUP($A2,{"ENGLISH","MATH","SCIENCE"},{5,9,11}),$B1+1)
    Last edited by JohnTopley; 05-10-2021 at 10:56 AM.

  4. #4
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Re: Start counting depends on the value

    Thank you so much po for the 2 Suggestions. It works.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Start counting depends on the value

    Glad to help & thanks for the feedback.

+ 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] Counting the 15 best results from the start
    By Albert310 in forum Excel Formulas & Functions
    Replies: 43
    Last Post: 01-01-2020, 01:34 PM
  2. Replies: 2
    Last Post: 07-26-2019, 07:42 PM
  3. Start counting from a name
    By ancstorer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-06-2018, 10:18 AM
  4. Fill the Dates Horizontally depends upon start and end data & sat-sun if cell is yes
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2015, 09:06 PM
  5. Ms access Vba Save Data to xl depends upon 1 table pick & Depends 2 Upon fiterDate
    By breadwinner in forum Access Programming / VBA / Macros
    Replies: 14
    Last Post: 05-29-2014, 10:59 PM
  6. Counting with zero between it and start over if..
    By keis386 in forum Excel General
    Replies: 4
    Last Post: 04-15-2011, 09:42 AM
  7. Counting until a condition and then, again counting from start
    By amitraiforyou in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2010, 05:25 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