As I tried to explain very short in the title. I would like to delete rows that has duplicates "column Material", but still keep the entire row with higest number from a cell in the "column Version"
I have made an excell document (check the atachement i made) with two sheets, for better visualization. I would like that table looks like in the green sheet "desired_table". The data is in first sheet "Original Table"
In the original file i have apx. a few thousand rows
Macro would be great