multiple critera formula

[Gary]

In column A1-A20 I have days for a crew. In column B1-B20 I have names of
the crew. In column C1-C20 there are hours for the crew. Each crew member
has a timesheet made of rows in column E through J making up a week.



MON Anderson, Josh 8

MON Bailey, John 8

MON Blakely, Brett 8

TUE Eddings, Cindy 8

TUE Floyd, Bill 8

TUE Anderson, Josh 8

WED Bailey, John 9

WED Blakely, Brett 9

WED Eddings, Cindy 9

THUR Anderson, Josh 10

THUR Bailey, John 10

FRI Anderson, Josh 10

SAT Anderson, Josh 9

SAT Bailey, John 9

SAT Blakely, Brett 9

SAT Eddings, Cindy 9



MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY



If an employee works on Monday with those hours listed in column C, we want
those hours automatically listed under Monday in that particular individuals
timesheet cells.



There is a possibility of 20 employees that are all listed in a column
titled "Employees" in column K.



Assuming that the week day example above is "Anderson, Josh" timesheet, how
would we show automatically 8 hours in the Monday cell, 8 hours in the
Tuesday cell, 0 hours in the Wednesday cell, 10 hours in the Thursday cell,
10 hours in the Friday cell and 9 hours in the Saturday cell?



Thank you,

Gary

 

[Bernard Liengme]

An real candidate for a Pivot Table.
Try Help and these sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

and return if more details are needed
best wishes

 

[T. Valko]

Here's a small sample file:

Gary-timesheet.xls 14.5kb

http://cjoint.com/?fifyJfDHrW

Notice that I changed the column headers to match the format of the weekdays
in column A.

A single formula was used. The formula was entered in cell E2 then copied
across to J2 then down to row 6.

Biff

 

[Gary]

Bernard,

Thank you for the time and direction to sites covering Pivot Tables. I wish
to continue the study and understanding of Pivot Tables; yet would it be
possible in this case to offer a formula for the sake of expediting our
immediate need? We wish simply to find a way to isolate one cell per
employee per day. If one employee shows hours on one particular day, we
want to display those same hours in another cell.

Regards,
Gary