Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Maximum If Help
Thanks to the guys who helped on the 'Average If' post. Both worked <G
I now want to find maximum salaries and, unfortunately, I can't tweak the above solution. Essentially I have two columns 'Grade' contains the grade (1 to 10) of every employee 'Salary' contains their salary. I want to calculate the maximum salary for each grade Can SKS give me the syntax TIA Robin |
#2
|
|||
|
|||
=MAX(--(grade=1)*salary)
entered as an array formula by pressing Ctrl-Shift-Enter "RFJ" wrote: Thanks to the guys who helped on the 'Average If' post. Both worked <G I now want to find maximum salaries and, unfortunately, I can't tweak the above solution. Essentially I have two columns 'Grade' contains the grade (1 to 10) of every employee 'Salary' contains their salary. I want to calculate the maximum salary for each grade Can SKS give me the syntax TIA Robin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum of a formula | Excel Worksheet Functions | |||
solver- maximum profit | Excel Worksheet Functions | |||
Scroll Bar maximum value | Charts and Charting in Excel | |||
Is there a maximum number of non-contiguous columns that can be h. | Excel Discussion (Misc queries) | |||
What is the maximum text size in a cell | Excel Discussion (Misc queries) |