MAX function for a given Position Title
Rich wrote...
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
If you have job titles in col A starting in A2 and corresponding
salaries in col B starting in B2, and you enter a job title in cell D2,
the following array formula will return the highest salary for that job
title.
=MAX(IF(A2:A1001=D2,B2:B1001))
|