hi all.

I have need to find the max number from a list of numbers with a criteria. looks like this:

a | 1
a | 2
a | 3
b | 4
b | 3
b | 2

So the function need to get the max value for all rows where a. For example, the max of "a" would be 3.

So, I know that the MAX function would be involved, but I don't know how to get the function that would group all "a" rows together then find the max in that group.

any help please?