ExcelBanter - View Single Post

Craig

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.