Hello Members,

I have a spreadsheet where Iam trying to add the serial numbers in each row using the below formula

=IF(C149<>"";MAX($B$149:OFFSET(B150;-1;0))+0.1;"")

However, whenever I delete the rows in B column there will be error value in all other rows like #N/A

Whether it is possible to delete the rows without affecting the Formula ?

I heard there is a excel function "INDEX" to be used, please reply with your answers how to apply INDEX function to the above Formula


Regards,