+ Reply to Thread
Results 1 to 5 of 5

Start new count on new value in certain cell

  1. #1
    Registered User
    Join Date
    04-30-2019
    Location
    Rotterdam
    MS-Off Ver
    2011
    Posts
    3

    Start new count on new value in certain cell

    Dear readers,

    I am wondering how i could start a new count when the value in a certain cell changes value. I want to count the amount of user_pick in column B per match_id in column A. For match_id 1, the count_1 should thus be 15, count_2 should be 0 and count_3 should be 1.

    Then a new count should start at row 18 for the new match_id. Could anybody help me with this? Thank you very much in advance!

    Best,

    George
    Attached Files Attached Files

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

    Re: Start new count on new value in certain cell

    Hi & welcome to the board.
    In C2 copied down & acroos
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-30-2019
    Location
    Rotterdam
    MS-Off Ver
    2011
    Posts
    3

    Re: Start new count on new value in certain cell

    Thanks a lot for your reply, but i'm afraid it does not exactly do what I was aiming for.

    The match_id is just a random number. What I was hoping to do is to count the amount of 1s, 2s and 3s in column B, per each match_id. So, eventually, C2 untill C17 should read 15, D2 untill D17 should read 0 and E2 untill E17 should read 1, as B2 untill B17 contain 15 1s, 0 2s and 1 3. Would this also be possible?

    Thank you!
    Attached Files Attached Files
    Last edited by jba9211; 04-30-2019 at 10:53 AM.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,433

    Re: Start new count on new value in certain cell

    In that case try
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-30-2019
    Location
    Rotterdam
    MS-Off Ver
    2011
    Posts
    3

    Re: Start new count on new value in certain cell

    Perfect, thank you very much.

+ 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] Count number of times a number appears with count start from next cell of last occurr
    By lesliewheeler in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2018, 09:34 AM
  2. Start a Count from a cell dependent on the value of another
    By ColinUR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-10-2017, 09:22 AM
  3. Count "X" in specific cell on multiple sheets (Start:End!)
    By sjones1976 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-17-2015, 10:50 AM
  4. Replies: 2
    Last Post: 08-16-2013, 08:45 AM
  5. Replies: 6
    Last Post: 03-25-2010, 07:50 AM
  6. Start count over after blank cell
    By RPS4444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2008, 11:27 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