Minimum Formula
THANKS!!!!!!!!!
"Bob Phillips" wrote in message
...
=MIN(IF(A1:A20="Foreman",B1:b20))
which is an array formula, it should be committed with Ctrl-Shift-Enter,
not
just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"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.
|