I have date range in A coloum in sheet 2 and have specific data for the dates in D coloum in sheet 2. I want to count of data date wise in sheet 1
Coloum A – dats from start to end of month (total no of rows in coloum A 100)
Coloum D – Multipal value for each date & same values repeated for other dates.
I want count of date value wise and count of value in date wise.
How can i get the same using formula