Group numbers

[Anar]

Hi, everyone
I need help. The issue is described below.

Below is a list of invoice groups. Group number of the first group of invoices is 1 and it is written in front of the first invoice. I need to write a formula which will show me group number of each invoice group. The group number should be written in front of the first invoice number in each group. For example, there should be 2 in front of E3478, 3 in front of E621 and etc.


<table border="0" cellpadding="0" cellspacing="0" width="146"><col style="width: 60pt;" width="80"> <col style="width: 49pt;" width="66"> <tbody><tr style="height: 13.2pt;" height="18"> <td class="xl64" style="height: 13.2pt; width: 60pt;" height="18" width="80">Invoice
groups
</td> <td class="xl64" style="border-left: medium none; width: 49pt;" width="66">Invoices
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl65" style="height: 13.2pt; border-top: medium none;" height="18">1</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">E126854</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E126856</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E126858</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E126860</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E3478</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E3483</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E3485</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E3487</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E3489</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E3491</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E621</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E628</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E630</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E632</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E634</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E636</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E9874567</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E9874573</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E9874575</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E9874577</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E9874579</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E9874581</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E74582</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">
</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E74579</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl67" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E74581</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl68" style="height: 13.2pt;" height="18">
</td> <td class="xl67" style="border-left: medium none;">E74582</td> </tr> <tr style="height: 13.2pt;" height="18"> <td class="xl69" style="height: 13.2pt;" height="18">
</td> <td class="xl70" style="border-left: medium none;">
</td> </tr> </tbody></table>BR,
Anar

 

[Marcelo Branco]

Hi and welcome,

Type 1 in A3

In A4 put this formula
=IF(AND(B3="",B4<>""),MAX($A$3:A3)+1,"")

copy down

M.

 

[Anar]

Hi and welcome,

Type 1 in A3

In A4 put this formula
=IF(AND(B3="",B4<>""),MAX($A$3:A3)+1,"")

copy down

M.

Thank you, it was helpful

 

[Marcelo Branco]

Thank you, it was helpful

You are welcome and tks for the feedback

M.