Hi,
I'm new here, and a bit of an Excel newbie and would like to learn more but
for starters I have a question about trying to retrieve and sort information
from data in a worksheet.
I work in a laboratory that tests patients for genetic abnormalities and
this information goes into a system that we can pull out the data as a text
file that will go into Excel as a new worksheet.
What I want to do is this: In one column is the type of test and in
another is the date the specimen was received. I want to find out the
number of tests done for a particular month. I know I can do autofilter and
do longwinded counts using that but is there an easier way to do this? Some
sort of function? Would setting up the worksheet that is linked to Microsoft
Access a better way to routinely pull up information??
I'll be asking the boss to send me on a course I think!!
Any help would be appreciated.
cheers
Jasen