Incremental numbering based on a cell

B

Bill Lee

I have a column of numbers which need to start at 50000 and increase
by 1 depending on the adjacent column
e.g.
A B
1 50000 YES
2 50001 YES
3 NO
4 50002 YES

I cannot seem to get the logic for the incremental increase right and
would appreciate any help that you can give.

Thanks in advance

Bill Lee
 
P

Peter van Deelen

Hi Bill,

Supposing you have 50000 in cell A1 and a collection of YES's and NO's in
column B, type this formula in cell A2:

=IF(B2="YES";MAX(A$1:A1)+1;"")

and copy it down to the remaining cells in column A.

This works for my (Dutch) version of Excel.

Maybe you have to replace the semicolons by comma's.

Have fun,

Peter
 
Top