Forum Discussion
AwesomeSauce
Mar 06, 2019Copper Contributor
Formula help
Hi, I have a data range (dates) in one worksheet that tracks the date of the event. I want to summarise, by month/ Year, on a separate worksheet. However, I quite fancy NOT using explicit ranges so...
SergeiBaklan
Mar 06, 2019Diamond Contributor
You may do that by Pivot Table, please see attached
- AwesomeSauceMar 08, 2019Copper Contributor
Thank you - I must have completely formula blinkered not to think about pivots! :o