I have a spreadsheet with one column lists the Physicians' names, while other columns lists their patients' names and the date the patient was seen. My problem........I have to count how many appts each doctor had seen during a certain quarter of the year. I may have one doctor having 250 yearly individual patient appts involving 35 patients but only 75 individual appts patients involving 15 patients in a given quarter. How do I find each Doctor's name and match his name to his patients during a specific quarter of the year.
Ultimately, I need a way to count how many individual patients appts and the number of patients seen during a specific period of time by referencing 3 columns of data.
Ultimately, I need a way to count how many individual patients appts and the number of patients seen during a specific period of time by referencing 3 columns of data.