I have a workbook with 3 columns:
Column A (LEN = 11)
Column B (LEN = 12)
Column C (LEN = 12-1)

So I did a data compare with C and A....looking for any duplicates. Column B and C are an exact match, minus the far right digit (=LEFT(B2,LEN(B2:B7120)-1))

So instead of manually going thru each match and deleting the value in Column B, I would just like to sort by the colored cells in Column C, but have the adjacent cell in Column B sort with it.

Any help appreciated. Thanks!