method to sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One column has cells which display either a number greater than 1, or 0. I need to have another column where the cells show the same numbers as those greater than one, and for the zeros, a number equal to one plus the last number for the last 0 (e.g. the first time a 0 is located in column A, the cell in column b, same row, = 1, next time 0 is located, column b value = 2, etc.). Thanks very much, Jayne G.
 
Hi
enter the following in B1
=IF(A1>1,A1,COUNTIF($A$1:$A1,0))
and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Conditional Formatting - Excel 2003 2
Help needed 0
Sumproduct question 4
SUMPRODUCT HELP 2
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel VBA 1

Back
Top