View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Al
 
Posts: n/a
Default conditional minimum value of various cells?

I have two columns: column C has job functions, say engineer, cook, driver,
etc; column D has salaries.

I want to analyse the salaries: what's the min/max,median, mode, average
values for each of the job functions. (e.g., if data in column C = "driver",
then corresponding salary to be included in the data to be analysed.)

Hope someone out there has the answer!!