Thank you Ron. This appears to be a great help! One more quick one, why
about the MIN too? I inserted MIN and it did not work. Any ideas?

"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