Macro to retain rows by combining Max between 2 rows

[Kartikjain13]

Hi - I have EXCEL Data in the following Format:

Test ID STEP Run ID
1 1 333
1 2 333
1 3 333
1 1 555
1 2 555
1 3 555
1 1 567
1 2 567
1 3 567

Need a macro such that the result is displayed in following fashion (The macro should return the Test ID and Steps for MAX Run ID only). All other data should get deleted.

Test ID STEP Run ID
1 1 567
1 2 567
1 3 567

[Kartikjain13]

Test ID | STEP | Run ID