1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: sequential row numbering based on value in another column/cell

Discussion in 'Business Applications' started by mdiego, Dec 21, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. mdiego

    mdiego Thread Starter

    Joined:
    Dec 21, 2011
    Messages:
    12
    I need to provide seqential row numbers from 1 to N that relate to cells in another column when the cell value is greater than zero. For instance, if the column with data is column d and I have data greater than zero in cells d3, d4, d5, and d7 I'd like the row count in column c to read number 1 for c3, 2 for c4, 3 for c5, and 4 four c7. Cells c1 through c3 as well as c6 should remain blank. What formula do I use?
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    Try this in Cell C2

    =IF(D2>0, MAX($C$1:C1)+1,"")

    and then copy down all the rows that you want to test
     
  3. mdiego

    mdiego Thread Starter

    Joined:
    Dec 21, 2011
    Messages:
    12
    All that gives me is a number 1 in each cell in column C corresponding to the cells in column D where there's data >1. There's no sequential numbering, such as 1, 2, 3
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    worked for me
    see attached - i may not have understood
     

    Attached Files:

  5. mdiego

    mdiego Thread Starter

    Joined:
    Dec 21, 2011
    Messages:
    12
    Genius! It works!!!!!!
     
  6. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,891
    First Name:
    Wayne
    not sure why it did not work for you first time

    glad to have helped


    (y) thanks for letting us know
    You can mark your own threads solved using the [​IMG] button at the top of the page of the thread in the upper left corner. :)
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1032295

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice