oNE SIMPLE WAY IS USING A HELPER AND HIDDEN COLUMN. lET'S SAY COLUMN c.

In C1 and copy down use this.

=LEFT(B1,6)+0

Then use (MAX(C:C)