Tech Support Guy banner
Status
Not open for further replies.

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

1K views 5 replies 2 participants last post by  etaf 
#1 ·
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?
 
#6 ·
not sure why it did not work for you first time

glad to have helped

:up: thanks for letting us know
You can mark your own threads solved using the
button at the top of the page of the thread in the upper left corner.
:)
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top