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
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
No comments:
Post a Comment