Question:

Question: How to add serial numbers to rows but skipping certain

Hi everyone! I'm looking for a way to add serial numbers to rows while skipping rows that contain certain texts. I tried the ROWS and COUNTAIF functions, but to no avail.


I hope the numbers in my spreadsheet could look like this: User uploaded file


Regards

Posted on

Reply
Question marked as Apple recommended
Answer:
Answer:

Hi M'


Does this do what you want?

User uploaded file

The formula, as written, depends on the continuation of the pattern exhibited in column B. (All 'headings' start with "TPO" followed by other characters.)


A1: IF(LEFT(B1,3)="TPO","",COUNTIF(B$1:B1,"<>TPO*"))


Fill down as needed.


Regards,

Barry

Posted on

Question marked as Apple recommended

Nov 15, 2018 8:38 PM in response to Ma.GY In response to Ma.GY

Hi M'


Does this do what you want?

User uploaded file

The formula, as written, depends on the continuation of the pattern exhibited in column B. (All 'headings' start with "TPO" followed by other characters.)


A1: IF(LEFT(B1,3)="TPO","",COUNTIF(B$1:B1,"<>TPO*"))


Fill down as needed.


Regards,

Barry

Nov 15, 2018 8:38 PM

Reply Helpful (1)
User profile for user: Ma.GY

Question: How to add serial numbers to rows but skipping certain