#1   Report Post  
RFJ
 
Posts: n/a
Default 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   Report Post  
Duke Carey
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum of a formula Ralph Excel Worksheet Functions 6 July 6th 05 10:20 PM
solver- maximum profit smallsun Excel Worksheet Functions 4 May 25th 05 04:09 PM
Scroll Bar maximum value Lee Charts and Charting in Excel 4 April 2nd 05 05:22 AM
Is there a maximum number of non-contiguous columns that can be h. Harold Excel Discussion (Misc queries) 6 March 1st 05 10:10 PM
What is the maximum text size in a cell ChaimB Excel Discussion (Misc queries) 4 February 20th 05 07:24 PM


All times are GMT +1. The time now is 05:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"