Try:

=MIN(IF($A$1:$A$6=A1,$B$1:$B$6))

entered as an array formula with Ctrl + Shift + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Craig" wrote in message
...
I need a formula to obtain the minimum wage for a specific job title that
are listed in a row. For instance I have the following information:

A B C

Foreman 17.50
Foreman 18.00
Asst. Foreman 15.00
Asst. Foreman 14.50
Welder 14.80
Welder 15.33


I need a formula in column C that would look at the job title in Column A
and give me the minimum amount a Foreman would make. For example in
columnC for both foreman the result of the formula would be 17.50. The
results for the Asst. Foreman would be 14.50. I then would have a formula
in column D that would show how much difference in the employees current
wage to the minimum amount for the person with similar job title.


Thanks for the help.

THANKS!!!!!!!
"Sandy Mann" wrote in message
...
Try:

=MIN(IF($A$1:$A$6=A1,$B$1:$B$6))

entered as an array formula with Ctrl + Shift + Enter

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Craig" wrote in message
...
I need a formula to obtain the minimum wage for a specific job title that
are listed in a row. For instance I have the following information:

A B C

Foreman 17.50
Foreman 18.00
Asst. Foreman 15.00
Asst. Foreman 14.50
Welder 14.80
Welder 15.33


I need a formula in column C that would look at the job title in Column A
and give me the minimum amount a Foreman would make. For example in
columnC for both foreman the result of the formula would be 17.50. The
results for the Asst. Foreman would be 14.50. I then would have a
formula in column D that would show how much difference in the employees
current wage to the minimum amount for the person with similar job title.


Thanks for the help.