Minimum Formula

[Craig]

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.

 

[smw226 via OfficeKB.com]

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

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.aspx/ms-excel/200610/1

 

[Bob Phillips]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Craig]

THANKS!!!!!!!!!

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

THANKS!!!!!!!

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk