Serial numbers in column A

Dear Experts,

I'm trying to get serial number 1,2,3,4 and so on in column A depending on tag in column B. Example in column A.. 1,2,3 serially but in 4th row in B column if tag is "Cancelled" then in column A 4th row should exclude for serial and serial number 4 should start from 5th row in column A and so on.

Thanks in advance

Please attach the workbook. There are instructions at the top of the page.

Please attach the workbook to THIS thread - do not create a new thread!

With a small addition:
=IF(or(B2="",B2="Cancelled"),"",MAX(A$1:A1)+1)

Put this on B2 and drag down as far as you need.

Formula:

Please Login or Register  to view this content.

Please don't forget the $ sign as shown above

Hope this helps