Quick Question

[Guest]

I wanted to know if there is a function(s) to help me.

I have data specified by days of the week (row), and then departments
(column). The data represented is total people in each department per day.
I want to find the highest # of people for the week, but only using each
department once.

Please Help

 

[Bob Phillips]

Perhaps

=MAX(b2:h2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

This help, will give me the highest number in each respective row. However,
finding the maximum in a set of cells is only half-way. I want to figure out
the best solution given I can only use a department once, within each week,
i.e. department a can only be chosen once, even if it has the most people
available every day.

Any thing else, you may have to add I would appreciate it.
--
Thanks,

Brian

Perhaps

=MAX(b2:h2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)