Greetings to you, friends and teachers
I have put an excel file here. In this table, in the b column, the names of a few pieces are registered (many) and in the column b of that part, for example: some only have a degree x, some have higher grades There is a fragment f to x3 and b to x1. Now I want to have a table of items with just their last degree, the result is like the table in the sheet 2, with vba or any other command. thank you for your help.
I have put an excel file here. In this table, in the b column, the names of a few pieces are registered (many) and in the column b of that part, for example: some only have a degree x, some have higher grades There is a fragment f to x3 and b to x1. Now I want to have a table of items with just their last degree, the result is like the table in the sheet 2, with vba or any other command. thank you for your help.