Hi "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."
File address: http://s9.picofile.com/file/8346492034/Table.xlsx.html
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."
File address: http://s9.picofile.com/file/8346492034/Table.xlsx.html
