Excel Formula

Senario

Column A should have serial number only when there is data in Column B 

Assumption : ROW 1 has header

Formula ( write in row 2 column 1 and drag)

=IF($B2="","",COUNTA($B$2:$B2))

Result