There may be better ways, but one way could be something like:

=MIN(IF($C$2:$C$100="engineer",$D$2:$D$100,""))

where your data is in rows 2 through 100.

You can use the same basic formula for MAX, MEDIAN, MODE, and AVERAGE (and
obviously for your other job functions)

NB: this formula must be array-entered (ctrl-shift-enter)

HTH,
Ryan

"Al" wrote:

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!!