A
Access Joe
Hey everyone,
Excel 2007
I have a set of data listed like such:
Column A COLUMN B
(DATES) (NAME)
4/1/2009 Joe
4/1/2009 Joe
4/1/2009 Mary
4/2/2009 Mike
4/2/2009 Ryan
4/2/2009 Mike
4/2/2009 Mike
4/3/2009 Larry
4/3/2009 Michelle
4/4/2009 Joe
4/4/2009 Ryan
4/4/2009 Joe
ETC.
This represents a schedule whereby each name is sometimes at different
locations through the course of one single day. What I want to do is figure
out how many DAYS the students are working. I can do an easy count of the
dates, but because a date is listed multiple times for different locations
and/or names, I can't figure out how to get the summary I need, which is
something like this:
Joe - 2 days
Mary - 1 day
Mike - 1 day
Michelle - 1 day
Ryan - 2 days
I don't want to run an Advanced Filter on Unique records. What I'm looking
for is a formula / Pivot Table feature that looks at each Date (not the
number of locations) uniquely for each name and updates automatically as new
data is entered. Any suggestions would be greatly appreciated!
Joe
Excel 2007
I have a set of data listed like such:
Column A COLUMN B
(DATES) (NAME)
4/1/2009 Joe
4/1/2009 Joe
4/1/2009 Mary
4/2/2009 Mike
4/2/2009 Ryan
4/2/2009 Mike
4/2/2009 Mike
4/3/2009 Larry
4/3/2009 Michelle
4/4/2009 Joe
4/4/2009 Ryan
4/4/2009 Joe
ETC.
This represents a schedule whereby each name is sometimes at different
locations through the course of one single day. What I want to do is figure
out how many DAYS the students are working. I can do an easy count of the
dates, but because a date is listed multiple times for different locations
and/or names, I can't figure out how to get the summary I need, which is
something like this:
Joe - 2 days
Mary - 1 day
Mike - 1 day
Michelle - 1 day
Ryan - 2 days
I don't want to run an Advanced Filter on Unique records. What I'm looking
for is a formula / Pivot Table feature that looks at each Date (not the
number of locations) uniquely for each name and updates automatically as new
data is entered. Any suggestions would be greatly appreciated!
Joe