Auto Increment ID

[marcusduton]

Hey Guy's I'm trying to create an auto increment for this work sheet.
Column A needs to increment only if a cell in column b has data that has been put in.

Please see attached sample.

[azumi]

Maybe put on A3 and copied down:

=IF($B3="","",COUNTA($B$3:B3))

or

=IF($B3="","",MAX($A$2:A2)+1)

[marcusduton]

Thanks that worked perfectly.