Filter by top Value in Column

Hi Guys, have a coding problem
I would like to filter Max Value in a group sorted by 2 columns
I have attached a small sheet with explanations
T sort order is in Cols A:B
Max value in col C
Thanks you in anticipation for your help
Regards
Graham

I don't understand.

Is your example the input data or the output?

Thanks Leith for your help, actually I probable did not explain correctly.
It must filter Max Value for each track and race No
So there will be a filtered number in D col for each track and race
Regards
Graham
The macro works file to filter only 1 (One) number

My Data is input and it must filter one number in D col for each track and race No
Regards
Graham

Maybe add to your sample what you want to see as an output for that input.

Mock-up your expected result.

Now posted revised data
Regards
Graham

try

Please Login or Register  to view this content.

Jindon that only returned I row
I better make this clearer....

I need a macro that will find the Max unique values that are filtered in Col G on sheet1 and copy all the data pertaining to the unique Max values in Col G to sheet 2 for eg if the top value in Col G are in rows 3, 10, 26, then copy the data from the other columns as well that are in the these rows


I have highlighted the Max unique values in Col G
Also included New Worksheet


It would be appreciated if someone would be able to assist me with my request

If you can not adjust the given code, don't make any excuse.

Please Login or Register  to view this content.

Thanks Jindon for your Help and Patience, works perfectly as u knew it would.
Very appreciative indeed
Regards
Graham Feeley