MAX function for a given Position Title
For MIN try this:
D1: =MIN(IF(($A$1:$A$5=D1),$B$1:$B$5))
Note: commit that array formula by holding down the [Ctrl] and [Shift] keys
when you press [Enter]
Does that help?
€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron
"Rich" wrote:
Ron,
Thank You, this is very helpful. How about the MIN side? I inserted the
MIN instead of the MAX and it did not work? Any ideas?
Rich
"Ron Coderre" wrote:
With data in cells A1:B4, try this:
C1: MNTWKR
D1: =SUMPRODUCT(MAX(--($A$1:$A$4=C1)*$B$1:$B$4))
Does that help?
€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron
"Rich" wrote:
Hello,
I have a 1000 line sheet that has multiple titles and so on. I like to
retrieve the highest salary for a given title. Position titles are not
sorted. Any suggestions on how this can be done?
example of the file:
MNTWKR $24500
SECY $21200
MNTWKR $30000
MNTWKR $28460
Appreciate any help on this.
Rich
|