Hi All,
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.
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.