Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick Question
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 -- Thanks, Brian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick Question
Perhaps
=MAX(b2:h2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Brian Hamilton" wrote in message ... 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 -- Thanks, Brian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quick Question
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 "Bob Phillips" wrote: Perhaps =MAX(b2:h2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Brian Hamilton" wrote in message ... 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 -- Thanks, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quick access bar | Excel Discussion (Misc queries) | |||
Quick little question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Worksheet Functions | |||
Quick question, just for interest... | Excel Discussion (Misc queries) | |||
Quick Question | Excel Discussion (Misc queries) |