I entered a formula which populates unique values from a list of names and number of times match with a date. I could use COUNTIF with MATCH and it gives correct result. Now I want the names also should be matched with date and only be listed if matches. So I tried to use COUNTIFS with match. But the array result of COUNTIFS with MATCH always gives 1. So it gives only first unique name.
For ex. as the attached file 'Sheila' is listed and the No Of Times is 0 since she didnt enter in report date 2/19/2015 ($I$1). So I wanted it to eliminate 'Sheila' for that report date. So I tried COUNTIFS instead COUNTIF with date criteria. But it only list 'Lucas'.
Thanks in advance.