Filtering Data

D

Dee

I have a spreadsheet that contains a column for
Investigator Name, Pt. ID and Date of Enrollment as
follows. I need to filter how many patients were
enrolled by each site per month. Should I use an
advanced filter, I'm not sure how to do this. Any help
would be greatly appreciated.

Investigator Pt. ID Date
Dr. Black
01-001 08/09/03
01-002 08/09/03
01-003 08/12/03
01-004 08/13/03
Dr. Smith
03-001 08/16/02
03-002 08/16/02
03-003 09/06/02
03-004 09/06/02
03-005 09/06/02
03-006 09/20/02

Regards,
Dee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top