Hi All,

I am in need of counting the values from two sheet. In first sheet I have a column with dates and in second sheet I have a column with date and another column has different values with duplicates. First criteria: date then second criteria: distinct values. Hope its clear If need i will attach the sample file. I need the count to be updated in first sheet. Thanks in advance.

Sheet 1
Date Agent Count
16-04-2020 3 < --- Expected Output
17-04-2020 2
20-04-2020 1

Sheet 2
Date Agent Name
16-04-2020 A
16-04-2020 A
16-04-2020 B
16-04-2020 C
17-04-2020 D
17-04-2020 D
20-04-2020 E