+ Reply to Thread
Results 1 to 4 of 4

Create row numbers for non blank rows based on criteria in 2 columns

  1. #1
    Registered User
    Join Date
    09-03-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    11

    Question Create row numbers for non blank rows based on criteria in 2 columns

    Hello,

    Trying to create a row number for each row where there's data (not blank) for each Project Number and maintain the row count when an earlier Project Number reappears further down.

    Here's an example:

    Project Number TaskId Desired Result
    998 T34 1
    998 T43 2
    998
    998 T78 3
    998 T90 4
    998
    998 T83 5
    998 T83 6
    999 T21 1
    999
    999 T83 2
    998 T12 7


    I'm thinking a combination of RANK and COUNTIFS is needed but can't wrap my head around this.
    Last edited by WorkHard1; 09-03-2021 at 10:31 AM.

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

    Re: Create row numbers for non blank rows based on criteria in 2 columns

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

  3. #3
    Registered User
    Join Date
    09-03-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    11

    Re: Create row numbers for non blank rows based on criteria in 2 columns

    How about if I add a count per month to this?

    I transformed a date into a month-year text and I tried
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Here's what I mean:

    Project Number TaskId Month Desired Result
    998 T34 1-2021 1
    998 T43 1-2021 2
    998 1-2021
    998 T78 1-2021 3
    998 T90 1-2021 4
    998 1-2021
    998 T83 1-2021 5
    998 T83 2-2021 1
    999 T21 2-2021 1
    999 2-2021
    999 T83 2-2021 2
    998 T12 2-2021 2

    Edit. Ah. Realized my mistake.
    Thanks again!
    Last edited by WorkHard1; 09-03-2021 at 12:01 PM.

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

    Re: Create row numbers for non blank rows based on criteria in 2 columns

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

+ 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] Macro to create separate tabs based on columns criteria
    By backyardfun in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-28-2021, 12:07 PM
  2. Create new rows based on numbers in cells
    By CaptainK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2014, 09:18 AM
  3. [SOLVED] colour row based on column criteria ,populated by numbers or blank
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-30-2013, 04:14 PM
  4. Create new tab + paste columns based on multiple criteria
    By imatias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2012, 11:00 AM
  5. Combine rows based on blank columns
    By motomoto1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2010, 10:12 AM
  6. Hide Blank Rows based on 2 columns
    By yzer19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2008, 11:23 AM

Tags for this Thread

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