I am struggling to get something to work - I think it may be pretty simple but no matter how many different variations of MAX(IF) I try it does not seem to work.

In COLUMN U I have a range of large values and am grouping my data based on this. So for example greater than 10000 and less than 15000 would make one group.

I now want to return the highest value in COLUMN G based on the corresponding criteria specified above.

Any help would be appreciated!

Cheers.