Hi

Ill try and explain this.... I need to find the Max(Column 3) for each group in Column 1 for each group in column 2....

lets say i have a table of employess structured like this......[Name], [Month], [Values]

so lets assume these values


Paul | Jan | 9
Paul | Jan | 10
Paul | Feb | 4
Paul | Feb | 13
John | Jan | 1
John | Jan | 7
John | Jan | 4
John | Feb | 13

i want to find the max value in column 3 per person per month

output would be (or variation of )

Paul | Jan | 10
Paul | Feb | 13
John | Jan | 7
John | Feb | 13


I can get the max value for each person, or the max value for each month, but i cannot seem to use the same technique to get the max of each group.... any ideas?