Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List from a table
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup? list data into summary table | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions |