Based on 2 criteria checks, create sequence numbering

**nerzzul** · 05-02-2023, 06:08 AM

Dear Experts,

could you pls support to create a formula, where based on 2 criteria checks, if they are duplicates to create a sequence number for the product number in unique format?

pls refer to the enclosed sample for further details.

Thanks,
N

**TMS** · 05-02-2023, 06:22 AM

Try this formula copied down:

Formula:

Please Login or Register  to view this content.

**nerzzul** · 05-02-2023, 06:39 AM

Thank you so much! it worked very well.

Reputation add =)

**TMS** · 05-02-2023, 06:43 AM

All in one go:

Formula:

Please Login or Register  to view this content.

**TMS** · 05-02-2023, 06:44 AM

You're welcome. Thanks for the rep.

Based on 2 criteria checks, create sequence numbering

LinkBack

Thread Tools

Rate This Thread

Display

Based on 2 criteria checks, create sequence numbering

Re: Based on 2 criteria checks, create sequence numbering

Re: Based on 2 criteria checks, create sequence numbering

Re: Based on 2 criteria checks, create sequence numbering

Re: Based on 2 criteria checks, create sequence numbering

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating a sequence based on criteria

Create a sequence based on a date in another column

sequence numbering

[SOLVED] Numbering Sequence based on two criteria.

Create a number sequence and restart when a cell value equals a criteria

I would like to create a macro that checks one cell and moves a row based on that

[SOLVED] Formula which checks whether a string is found in a range and checks 2 criteria

Bookmarks

Bookmarks

Posting Permissions