sam singha
Member
Hey friends,
Please find the file attached which on sheet 1 shows sample data. In the summary sheet i want to capture the count of patient names for a particular date. Ex. for Jan 1st for user Sam 7 patients etc. I cannot use a pivot since the data of each user will be placed in a different sheet of common shared file. The count will show their productivity for that particular day. i have tried countif but didnt work.
i want excel to capture of patient names for a particular date from the date row in a separate summary sheet.
Any help will be relieving, thanks in advance!!
Please find the file attached which on sheet 1 shows sample data. In the summary sheet i want to capture the count of patient names for a particular date. Ex. for Jan 1st for user Sam 7 patients etc. I cannot use a pivot since the data of each user will be placed in a different sheet of common shared file. The count will show their productivity for that particular day. i have tried countif but didnt work.
i want excel to capture of patient names for a particular date from the date row in a separate summary sheet.
Any help will be relieving, thanks in advance!!