Good morning to all of you.

Has anyone faced the following situation?

I have a list that contains the following columns
- Day of the month
- Time

I would like to create a summary table using the SUMPRODUCT formula to
determine the number of calls per time period during the day in a dynamic
way.
That would mean:
- having a formula or macro that would scan the Day column and list unique
occurences of a day (for instance Day2, day1, day1, day2, day2, day2, day2,
day3... would give me a list with 3 values Day 1, Day 2, day 3
- having a formula or macro that would scan the timecolumn and list unique
occurences (7-8, 7-8, 8-9, 8-9...) would give me a list with 2 values 7-8,
8-9

Final result like
7-8 8-9
day 1 1 1

day 2 1 1

Thanks for your help in this matter