Forum Discussion
Excel tables or formulas for data analysis
I have a data set of all our inbound calls from last week and what times the calls came in. To be able to monitor when our peak periods were, I want to create a pivot or table that tells me how many ...
hey thanks
its just not letting me see any formulas in that sample sheet... would you be able to send the formula you used in column D of the sample please?
Tysm
loljay
Here are couple of more variants
- PivotTable (if you work with data model)
- formula (if you work with dynamic arrays, i.e. Excel 365 or 2021)