Forum Discussion
Count unique values in a range from a worksheet with more than 1 criteria
I need distinct counts from 1 worksheet onto another where the criteria is by date and the other is by a name. Below is what I was hoping would work but it does not. Can anyone help? =COUNTIFS(...
Do you happen to have a sample you can upload? This might be do-able with a pivot table and distinct count OR with UNIQUE (and a few more functions), if you're on 365.
I'm wanting to try to stay away from a pivot table since this will be an on-going report, there will be a worksheet per employee. Trying to keep track of work done. Only examples that I have are what is in the discussion, worksheets that I'm trying to pull the information from.