Numbering Sequence based on two criteria.

Hello -

I have a data sheet with sets of serials. Each set of serials is divided in two forms. The first form is the RMA# (which is a set of 40 serials), and secondly by Box# (wich is a set of 10 serials).

My goal is to know how many serials are in each set and the Max of Boxes per set. I figured out the first part (to know how many serials are included in a set) (RMALine). But I am having trouble setting the second goal (The max of boxes per set).

Basically saying, to give sequential numbering (1, 2, 3, ....) to each box in the RMABox column until the next RMA# appear. And then restart the sequence.

Two criteria must be met:
1st Criteria: RMA #
2nd Criteria: Box #

Also, I prefer Formula/Function and not VBA Code due to IT Systems Security.

Can anyone help me?? I am attaching excel file for reference.
Thank you very much for the support.

SamCV.
Matamoros, Mexico.

Hello daffodil11 and benishiryo...

I am glad to receive your help. Both answers are of great help. But the formulas counts the max of serials in each box. I need to assign sequential numbering to each box of the RMA.

I modified a little bit the reference file so you can see what the goal is. Column E (RMABox) must look like Column D.

I really appreciate your time and effort.

SamCV.
Matamoros, Mexico.

Originally Posted by benishiryo

maybe you can try this:

Formula:

Please Login or Register  to view this content.

Amazing!!! It worked smoothly!!!!

Thank you very much!!! This will help me a lot with my Database.

How can I mark this thread as SOLVED?? I know how to add reputation.

Best regards and please have an excellent day!!!
(Saludos cordiales y que tengas un excelente día!!!)

SamCV.
Matamomoros