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.

Hi Craig,

The easiest way I can think of is to create a pivot table on your data and
have "Column A" as your row data and "Min of Column B" for data and then use
the V Lookup function to get the data back into your orgional sheet.

HTH

SImon

Craig wrote:
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.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1

=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.

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.

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.