+ Reply to Thread
Results 1 to 8 of 8

Conditional Counting of Rows

  1. #1
    Registered User
    Join Date
    11-17-2017
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2016,2013
    Posts
    6

    Conditional Counting of Rows

    Hello everyone,

    Can anyone help me with Conditional Counting of Rows?
    So, in column A I have Job ID by rows, and in column B I have a number of rows from column A with same Job ID. What I need is a formula that would count the same Job ID by rows and put the value of counted rows in column B parallel to Job ID - better to say in the first cell where Job ID sequence starts. The rest of the rows should be null, until the new Job ID.
    Thanks.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: Conditional Counting of Rows

    Please Login or Register  to view this content.
    Try this formule in B2
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    11-17-2017
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2016,2013
    Posts
    6

    Re: Conditional Counting of Rows

    hello, popipipo

    it works great, it gives me a small error but it is doing the job exactly what I need, I will pull the formula for my column and the jus copy paste the values

    again thanks very much

  4. #4
    Registered User
    Join Date
    11-17-2017
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2016,2013
    Posts
    6

    Re: Conditional Counting of Rows

    I have one more question if you can help please, this formula work excellent, but I just remembered that I need the third column in which instead null will just be put the number of counted row from column A by Job Id, can you help with that

  5. #5
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Conditional Counting of Rows

    Answers original query
    Another formula in B2 copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by kev_; 11-17-2017 at 06:03 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Conditional Counting of Rows

    I have one more question if you can help please, this formula work excellent, but I just remembered that I need the third column in which instead null will just be put the number of counted row from column A by Job Id, can you help with that
    Try in C2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  7. #7
    Registered User
    Join Date
    11-17-2017
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2016,2013
    Posts
    6

    Re: Conditional Counting of Rows

    don't know how to set up this formula in column C, to put counted the number of rows as continuous until the next given job id is counted
    Attached Images Attached Images

  8. #8
    Registered User
    Join Date
    11-17-2017
    Location
    https://t.me/pump_upp
    MS-Off Ver
    2016,2013
    Posts
    6

    Re: Conditional Counting of Rows

    the number of rows by Job Id is needed so I could solve problems with column D and E
    can anyone help me whit this formula?
    I have no idea how to set up this?
    Attached Images Attached Images

+ 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. Replies: 4
    Last Post: 07-13-2017, 12:24 AM
  2. need help with counting criteria without counting duplicate rows
    By lya in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2012, 10:14 PM
  3. Replies: 6
    Last Post: 02-04-2012, 06:57 PM
  4. Conditional Counting
    By andrewc in forum Excel General
    Replies: 3
    Last Post: 10-20-2009, 06:20 AM
  5. conditional counting of autolist cells/rows
    By johli in forum Excel General
    Replies: 0
    Last Post: 09-23-2005, 08:45 AM
  6. [SOLVED] Counting rows, then counting values.
    By Michael via OfficeKB.com in forum Excel General
    Replies: 7
    Last Post: 08-04-2005, 06:05 PM
  7. Counting Rows Then Counting Values in Columns
    By Michael via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2005, 12:05 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