The user need to count how frequently a specific number occurs on a specific day.
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
|How to drag every Nth column, with varying starting column by date|
|How to use a VBA code to change cells colours based on date in other cells|
|How to count non blanks 5 years from the last non blank date|
|How to use SUMPRODUCT with dates|
|How to sum up values in a date range|