Hi,

Could any one please help me in finding the latest bill number in a column based on the text string available in each bill number.

Bill No.
DELPL-2018-19-001
DELPL-2018-19-002
DELPL-2018-19-003
ALPL-2018-19-001
ALPL-2018-19-002
DELPL-2018-19-004
ALPL-2018-19-003
DELPL-2018-19-005
ALPL-2018-19-004
IQLPL-2018-19-001

In the above list of bill numbers there are text strings in begging. Those are the company names. Based on these text string latest next available bill number to be considered for next bill generation. For Ex. If we have to raise a bill in ALPL company, the latest next bill number available is 005 and for DELPL company 006 & for IQLPL company 002.

Based the results in B1 next invoice number will be picked for next billing.

Please help me on this.