Quick Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Hamilton - 27 Oct 2006 16:54 GMT

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

Signature

Thanks,

Brian

Reply to this Message

Bob Phillips - 27 Oct 2006 17:18 GMT

Perhaps

=MAX(b2:h2)

Signature

HTH

Bob Phillips

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

> I wanted to know if there is a function(s) to help me.
>
[quoted text clipped - 4 lines]
>
> Please Help

Reply to this Message

Brian Hamilton - 27 Oct 2006 17:51 GMT

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.

Signature

Thanks,

Brian

> Perhaps
>
[quoted text clipped - 9 lines]
> >
> > Please Help

Reply to this Message