select multiple rows and only highest value

Hi
I am not sure whether this should be resolved in VB or VBA. I have not used either for a couple of years and am struggling to get what I need.

I was wondering if anyone could help as I have been racking my brain for a few days now and seem to have gone backwards.

I have a speadsheet with hundreds of rows and I need to do some selective searching and return specific rows.

example; I have attached a small excel sheet to display my probem

It should be ordered by column 'C' order number.

Then display the highest value in column 'A'

but only if the date in column J is greater than 8 days

The whole row for that data needs to be returned, and it doesnt matter if the results are shown on a different page

Can anyone please help?

Regards
Wibbers

Hi Wibbers, welcome to VBForums!

You appear to have left off the attachment ;)

sorry my mistake, I tried to upload a excel sheet.

file is now attached

regards