Sequential Numbering in Rows Dependant on Other Inputs

[thylacine75]

I'm having a massive problem getting an auto filling sequential number down a list of rows (column A). If one box has a value greater than 0 (column G)then I want to input a number (starting at 1). If one or several rows don't have this input I need that cell left blank, but need to keep the sequence of numbers going when that input has been made. Any ideas how to do this?

A	B	C	D	E	F	G
1	2	4	2	1	2	2
2	4	6	2	1	3	3
3	6	7	1	1	2	2
	7	7	0			0
4	8	9	1	1	3	3
5	9	10	1	1	2	2

<tbody>
</tbody>

 

[AlanY]

try this in A2, and copy down

=IF(G2>0,MAX($A$1:A1)+1,"")

 

[thylacine75]

Superb! Thanks.

 

[AlanY]

you're welcome