View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich
 
Posts: n/a
Default MAX function for a given Position Title

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