Max values in various Columns

I have the following problem.
I need to first group the NODOB(T) column to the same nodes. For example group all the PVAB0001... PVAB0002... then for that group find the maxium value in the following columns [F:I] that correspond to that group. There is a sample of the excel file.
I need to apply a macro as this is a sample and the original file has 62300 to process. Any help would to great.