I am wondering if Excel has an easy way to return sequential numbers for a FALSE If statement.
My working formula is =IF(ID#=0,"",{1,2,3...}) where {1,2,3...} would be sequential numbers.
ie.

ID#
0
0
72408003
0
72408005
0
0
72408008

Ultimately I would like the next column to return something like this:
ID#
0
0
72408003 1
0
72408005 2
0
0
72408008 3

I am not that great at excel, so any help would be very useful.

Thanks!